Show currency with symbol based on region of execution in SSRS 2012

The following article explains different possible ways to show currency with symbol in the report. Further we will specifically see how based on region of execution, the corresponding currency symbol changes in SSRS.

---

Create new 2012 SSRS project and create new SSRS report. 

Method 1. Using Text Box Properties

Right click on the Report Designer tab and select Insert > Text Box. 

Right click on Text Box and select Expressions to open Expression dialog. 

Type 10000 after = and click OK button. 

Right click on Text Box and select Text Box Properties. 

Select Number. Under Category, select Currency. Set the currency symbol under Symbol and leave to default other values. Click OK. 

Preview the report and we should see currency symbol added to numeric value.

Method 2. Using FormatCurrency in Expression

Right click on the Report Designer tab and select Insert > Text Box. 

Right click on Text Box and select Expressions to open Expression dialog. 

Under Category, expand Common Functions and select Text. Double click on FormatCurrency (This function shows currency symbol as $ by default) under Item and complete the expression as shown: FormatCurrency(20000, 2). Click OK button. 

Preview the report and we should see $ symbol added to numeric value. 

Method 3. Using Language Build-in function and, Language and Format Property

Right click on the Report Designer tab and select Insert > Text Box. 

Right click on Text Box and select Expressions to open Expression dialog. 

Type 30000 after = and click OK button. 

Selecting the Text Box, click F4 button or select View>Properties Window. 

Select Language Property and select Expressions. 

Under Category, select Built-in Fields. Under Item, double click Language. It specifies the language setting of the current system. Click OK.

Specify c under Format. This specifies that the value in Text Box should be treated as currency. 

Before checking the report preview, we will see the current system currency symbol. In Windows 8, it is mentioned under Control Panel > Clock, Language, and Region > Region > Additional Settings button > Currency tab. 

Preview the report and we should see system currency symbol added to numeric value.

Please feel free to correct me by commenting your feedback and suggestions.