Microsoft Dynamics NAV (Archived)

Format number in ssrs report

(0) Share

Report

Posted on by manish.yadav

1,893

Dear Experts,

I am facing problem to set the comma in invoice value figure. for foreign customer.

What expression I need to use. My current expression is =Format(Fields!round_amt_to_customer.Value,"##,##,##,###.00")

EX. - USD 1,64,81,937.92 I want to write like this

USD 16,481,937.92

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

manish.yadav 1,893 on at

Like (0)

Report

RE: Format number in ssrs report

Thank you for your reply sir.

Through the below link, I have resolved the query from my own.

blogs.msdn.microsoft.com/.../how-to-change-thousandsdecimals-separators-in-rdl-reports

The link is very helpful.

Please close this thread.

Was this reply helpful? Yes No
Suggested answer

Muratvzr 743 on at

Like (0)

Report

RE: Format number in ssrs report

Helle please first look at the report language different languages has different cultures so it's not applying sometimes and the best way to make field format is text box number properties if n2 is not working than go to custom and write #,##0.00 something like that

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

RE: Format number in ssrs report

Yes, Textbox91 is the control of this report and it is available in body section and I am using in footer section.

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Format number in ssrs report

It seems that Textbox91 is not a control in your RDLC. Is it correct the name of your control that you want to reference (where you've set the decimal fields)?

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

RE: Format number in ssrs report

I am doing the same from your suggested link. When I try to save the report, I am getting the error messages, my expressions are below:

=ReportItems.Textbox91.Value

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Format number in ssrs report

In Headers and Footers in RDL Layout we cannot just add fields from the dataset. Instead, we must add the field to the Body of the report (but hide it), and then use the ReportItems! collection in the header to refer to the field in the Body.

Check here how to use ReportItems! :

msdn.microsoft.com/.../bb934329.aspx

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

RE: Format number in ssrs report

Dear Stefano,

Through google, I have got a link. I have implemented in my report code. But it is working only in body section. Invoice total amount is showing in footer section.

If you understand the given link, please give me tips, how can I implement in report footer.

blogs.msdn.microsoft.com/.../how-to-change-thousandsdecimals-separators-in-rdl-reports

I am waiting for your positive response.

Was this reply helpful? Yes No
Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Format number in ssrs report

The previously described settings + settings the Language property of the textbox correctly should work...

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

RE: Format number in ssrs report

I have already done it. But there is no effect.

After each 100 separator should come.

Like 85808580

Output should be

85,808,580

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Format number in ssrs report

Hi ,Please select textbox then right click - then go to text box property- select number- tick the check box (regional formatting & 1000 separate ).

As per below Screenshot,set your requirement .

Please let me know ,If it help you.

Was this reply helpful? Yes No