Changing Decimal after Points in a value

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Dear Experts,

I want to change decimal value as shown in the Report. For example in the highlighted color the value i 15.000 just example, but i want as 15.00, means in place of 3(000 zeros) 2(00 zeros). just for one item not for all is it possible.

Thanks and Regards,

Shabir Ahmad

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Mea_ 60,284 on at

Like (1)

Report

RE: Changing Decimal after Points in a value

Hi Shabir Ahmad,

In the report you can set cell format to "N2" or use more advanced options from this blog post stoneridgesoftware.com/formatting-columns-in-ssrs-reports

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Changing Decimal after Points in a value

ievgen Miroshnikov ,

I think you are talking about this place,which is already with 2 decimal points.

Thanks and Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Changing Decimal after Points in a value

ievgen Miroshnikov ,
Please check more information for your knowledge.if there are something else to show you, please tell.

Thanks and Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

RE: Changing Decimal after Points in a value

It's hard to say from your screenshot that format applied to that cell, also if you changed it you need to check that report is redeployed and you refreshed cache using AX client in Tools -> cache -> refresh report server menu.

Was this reply helpful? Yes No
Verified answer

Shabir Ahmad 3,110 on at

Like (0)

Report

RE: Changing Decimal after Points in a value

Thanks for your reply,

The issue has been resolved, i just changed( in InventTestCertOfAnalysisDP class method (insertIntoTempTable)) the unitdecimalprecision from 3 to 2 now , that resolve my issue. please check the above image as well.

Thanks and Regards,

Shabir Ahmad

Was this reply helpful? Yes No