The SSRS FormatNumber function is a text function that formats the expression or numeric fields as numbers and controls the decimal values. The syntax of the FormatNumber function to format the numeric fields or numbers is as shown below. Here, the second argument is the decimal precisions.
=FormatNumber(Fields!SalesAmount.Value, 2)
To demonstrate the SSRS FormatNumber function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS FormatNumber function Example
For this, let me add a new column to the right side of the Sales column. Next, right-click the textbox under the SalesFormat Name and choose the Expression. To understand the report, I suggest you refer to the articles on charts, tables, grouping, and format tables in SSRS.
It opens the following expression window to format the sales numbers. The below SSRS FormatNumber function will format the sales value and set the decimal precision as two (two digits after decimal).
=FormatNumber(Fields!Sales.Value, 2)
Similarly, let me create one more new column to the right of the Sales. Here, we assign 3 as the second argument. This means that the FormatNumber function formats the sales numbers column with three decimal precisions.
=FormatNumber(Fields!Sales.Value, 3)
Please click the preview tab to see the report. If you observe the values, they are automatically rounded to the nearest number after the decimal. For more functions, Click Here!
