Forum Discussion

aliahad's avatar
aliahad
Frequent Visitor
1 year ago
Solved

Paginated Report column formatting

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:   ...
Paginated Reports
  • aliahad's avatar
    aliahad
    1 year ago

    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.

aliahad's avatar
aliahad
Frequent Visitor
1 year ago

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.

aliahad's avatar
aliahad
Frequent Visitor
1 year ago

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.