Reporting Services

How To Change Numbers Format in Reporting Services

Friday, April 24th, 2009
at 6:37pm

Trusted By

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:

Reporting Services Language Setting

You can change it to French or whichever language you are using and the number format would follow.

Hope this helps.

Hatim