The SSRS FormatCurrency function is a Text function that formats the numeric (number) fields as the currency value and assigns the currency symbol defined in the system control panel. The syntax of the FormatCurrency function to assign a currency symbol to the formatted numeric fields is as shown below. Here, the second argument is the decimal precision.
=FormatCurrency(Fields!SalesAmount.Value, 0)
To demonstrate the FormatCurrency function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS FormatCurrency function Example
For this, let me add a new column to the right side of the Income column. Next, right-click the textbox under the Income Cur Name and choose the Expression. To understand the report, I suggest you refer to the articles on SSRS charts and SSRS table report from our SSRS tutorial page.
It opens the following expression window to format the Currency. The SSRS FormatCurrency function will format the numeric value in the income column and add the c currency symbol. It assigns the system local currency symbol (Here, it is $). Also, check out the SSRS grouping and format tables in SSRS articles.
=FormatCurrency(Fields!Income.Value, 0)
Similarly, let me create one more new column to the right of the Sales column. Here, we assign 2 as the second argument. This means the FormatCurrency function formats the Sales column and adds the Dollar currency symbol with two decimal precisions.
=FormatCurrency(Fields!Sales.Value, 2)
Please click the preview tab to see the report. Please refer to the SSRS FORMATNUMBER function from the list of available SSRS functions.
