How To Change Numbers Format in Reporting Services
- 4
- Add a Comment
Welcome Back! I hope you enjoy the content on this site. If you have not done so already, you may want to subscribe to my RSS feed or become a fan of this blog on Facebook. Thanks for visiting!
This one had me spinning for a while, so I am sure someone else would get some value out of this post.
Our client had a French version of Microsoft SQL Server 2005 and Reporting Services but on their reports the numbers format was using a comma as the thousands separator and the point as the decimal separator. They wanted it to use the French number formatting which is the space as the thousands separator and the comma as the decimal separator.
I started by looking at the Reporting Services Options and then SQL Server options but I couldn’t find anything to set the locale or number formatting.
So I started looking at the report properties in Visual Studio and there it was:
You can change it to French or whichever language you are using and the number format would follow.
Hope this helps.
Hatim
4 Comments
beren
June 10th, 2009
at 12:19pm
Thanks a lot, this is very useful! I also discovered that this property could be modify to object level so you could specify different localization for different textbox in the same report!
Very cool
claudio
June 16th, 2009
at 1:43pm
Thank you very very much!
It helped me a lot :-)))))
patLim
August 27th, 2009
at 3:48pm
You can also go on the properties of the textbox witch hold the number to format.
Select number
After Select Custom in the list on the right and you can enter this format.
### ### ###
it’s another way to do.
Marc Allard
October 22nd, 2009
at 8:47am
Hello,
It is not working correctly if the customer has changed the default settings for his language.
For example, in Belgium, the decimal separator is the “,” and the number grouping is the “.”
One customer has decided to use the space (” “) instead of the “.” for the grouping number, and the report always use the “.”
Even with the value User!Language it doesn’t work.