SSRS 2008 reports are being developed using T-SQL Queries. The requirement is to display the numbers in Indian format. E.g 1234568 should be shown as 12,34,568. SSRS is applying thousand seperator(i.e 1234568 is shown as 1,234,568) only, though number format is set to regional settings for all the report items and the regional settings in report server machine are set to the required format. We tried custom formats also but invain. Is there is any solution for this problem. Thanks in advance.
+1
A:
Will this help?
http://agilebi.com/cs/blogs/jwelch/archive/2008/12/16/formatting-numbers-in-ssrs-and-ssas.aspx
social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/836141dd-097f-402e-ae95-f561cbf3b6c6/
Prasanna Prabhu
2009-12-19 17:09:37
The first link did not help because it spells out a way to show numbers in 10K instead of 1K. The custom code outlined in the second link helped me. Thanks
narayanamarthi
2009-12-21 05:09:35
Just out of curiosity, but would changing the region settings also be a possible fix?
avgbody
2010-01-11 17:52:19