Katie & Emil
BI Specialists

Home >SQL Server >SSRS

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



News & Updates:

You like it? Share it!

Comments Add Comment
No data was returned. Shere your thoughts, questions and suggest improvements:
Add Comment
 Recommend & Share
 

 

 Add Comment