topic Re: Paginated Report column formatting in Report Server

Paginated Report column formatting

aliahad — Mon, 18 Aug 2025 18:21:46 GMT

Hello,

I have create a paginated report but number formatting is not working, I have changed the 'Text Box' property for the cell but my output is still displaying number with decimals:

I have refreshed my query multiple times but no luck.

Please advise.

Thanks,

Ali.

Re: Paginated Report column formatting

aliahad — Tue, 19 Aug 2025 04:27:18 GMT

Hi Jainesh,

I already have done that earlier and refreshed the data mutiple times but no luck.

When I create a new visualization I can see the fomat properly but it is not show translating to the paginated report.

Thanks,

Ali.

Re: Paginated Report column formatting

aliahad — Tue, 19 Aug 2025 15:06:03 GMT

Hi Jainesh,

The data type property was already showing the same, but I am still getting the extra decmals in the paginated report. I have saved the model, exit the Power BI and reopened it again but no luck.

Thanks,

Ali.

Re: Paginated Report column formatting

v-hjannapu — Wed, 20 Aug 2025 10:38:29 GMT

Hi aliahad,

Thanks for sharing the screenshots. In Paginated Reports, the number formatting that we apply in Power BI Desktop model doesn’t always reflect. Paginated report has its own formatting settings.

Can you please try this once:

1.Right click on the textbox in your paginated report → go to Text Box Properties.
2.Under Number → Custom, type a format like:
N0 → for whole number (no decimals)
N2 → for 2 decimal places

C0 → for currency without decimals
3.Press OK and run the report again.

Please find the attached screenshot for your reference.

This way you can control how the number shows in the paginated report, even if the dataset is giving more decimal values.

I hope this information is helpful to you. If you need any further clarification or assistance, please let me know.

Best Regards,
Harshitha.

Re: Paginated Report column formatting

aliahad — Wed, 20 Aug 2025 14:52:04 GMT

Hi v-hjannapu

I have tried your suggestion but that also doesn't solve my issue, the only thing left is to make the changes in the ETL process and hopefully that will give me the results that I am looking for.

Thanks everyone for all the help.

Ali.

Re: Paginated Report column formatting

aliahad — Wed, 20 Aug 2025 17:54:03 GMT

So I finally figured it out I use an expression to set value and getting the expected results.

CDbl(Column_Name)

and used the number format from the text box properties and it is working as expected.

Again, thank you every one for helping me as I definately learn some new ways of formatting.

Thanks,

Ali.