1,835
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
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.
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
Yes, Textbox91 is the control of this report and it is available in body section and I am using in footer section.
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)?
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
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! :
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.
The previously described settings + settings the Language property of the textbox correctly should work...
I have already done it. But there is no effect.
After each 100 separator should come.
Like 85808580
Output should be
85,808,580
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.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
