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)

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Format number in ssrs report

You can click the Text Box Properties, then Select the Number tab.

In the Category list, select Currency.

In the Symbol list, select your currency.

Click OK to close the dialog box.

It should be formatted correctly according to the currency selected.

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

Like (0)

Report

RE: Format number in ssrs report

Hi Stefano,

I appreciate your response. Unfortunately, this didn't solve our problem.

It is not possible to select the currency again and again. in report designer. How can I set it automatic.

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
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
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

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

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

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

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

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