Format Numbers in SSRS Report

In this article we will show you the step by step approach to format Numbers in SSRS Report, OR How to Format the Numeric values or Numbers present in a Text box in SQL Server Reporting Services 2014 with example.

To explain the available Numeric Format options, We are going to use below shown report. Please refer SSRS Table Report article to understand the Shared Data Source and Dataset we used for this report. If you observe the below screenshot, It was a normal report with Product Name, Color, Sales Amount and Tax Amount columns.

If you observe the above screenshot, The numeric values present in Sales Amount and Tax Amount columns are not attractive to impress the end-user (Too many numbers after decimal and no currency symbol etc).

Formatting Numbers in SSRS 2014

In order to Format Numbers in SSRS Report, Please select the Textbox containing Numeric values. In this example, Select Sales Amount Textbox of the SSRS report and Right click on it will open the context menu. Please select the Text Box Properties.. option from it

Once we click on the Text Box Properties.. option, a new Text box Properties window will be opened. Please select the Number tab as shown in below screenshot.

Format Number

Please select the Numbers Category from the available list.

• To remove the extra numbers from decimal place, Select the Decimal Place property and change the value to 2 as shown in below screenshot.
• Use 1000 separator(,): If you want to separate the 1000 with comma then Select this option

Click ok to finish Formatting the Numeric value of Sales Amount text box. Let us preview the report

Now, let us format the Numeric values in Tax Amount

Currency Format

Please select the Currency Category from the available list. To change the currency, Please select the required currency from the provided list

We selected the United States Dollar for this example

Click ok to finish Formatting the numbers in Sales Amount and Tax Amount columns. Let us see the preview

If you observe the above screenshot, Numeric data in Sales Amount and Tax Amount columns looks attractive and more meaningful

Thank You for Visiting Our Blog