Support our 100% FREE Projects: Donate Now OR Sponsor Now

  
›

SSRS thousands separator
If you are after SSRS Thousands Separator Formatting then you are in the right place.

I would like show you how to apply thousands separator using SSRS.

Below is a sample which shows a table with Performance Target Field which contains numeric values which are not seperated by thousands separator.
T-SQL Thousands Separator

To apply thousands separator go to design view and then right click the field where you want to apply thousands separator and select text box properties (see screen shot below)
T-SQL Thousands Separator

From the menu on the left select 'Number' and then from category list box select Number as well. You will get options related to number formatting. Tick "User 1000 separator (,)' and click ok
T-SQL Thousands Separator

Click preview and see the changes. See below final result after apply thousands sepator.
T-SQL Thousands Separator

Hope that helps!
Katie
Share: Share on FacebookShare on Google PlusTweet it
Comments Add Comment
Name: Yossi
Comment:

Thanks alot!!
Date Posted: 27/02/2013 2:20:04 PM

Share your thoughts, questions and suggest improvements:
Add Comment

You found us! Below are 50 most popular searched keywords

created at TagCrowd.com

Disclaimer: While every caution has been taken to provide our readers with most accurate information and honest analysis, please use your discretion before taking any decisions based on the information in this blog. Author will not compensate you in any way whatsoever if you ever happen to suffer a loss/inconvenience/damage because of/while making use of information in this blog.