Set the locale for a paginated report or text box (Report Builder)
Applies to: Microsoft Report Builder (SSRS) Power BI Report Builder Report Designer in SQL Server Data Tools
The Language property on a paginated report or a text box contains the locale setting, which determines the default formats for displaying report data that differ by language and region, for example, date, currency, or number values. The Language property on a text box overrides the Language property on the report. If no value is specified for Language, Reporting Services uses the locale of the operating system on the report server for published reports or of the report authoring computer for report preview.
For HTML reports, you can override the default Language value and use the language specified by the HTTP header of the browser client by using the built-in field User!Language in an expression for the Language property of a report or a text box.
You can also specify the Language property for a report in a URL. For more information, see Set the Language for Report Parameters in a URL.
To set the locale for a report
In Design view, click outside the report design surface to select the report.
In the Properties pane, for the Language property, type or select the language that you want to use for the report.
To set the locale for a text box
In Design view, select the text box to which you want to apply the locale settings.
In the Properties pane, do the following:
For the Calendar property, type or select the calendar that you want to use for dates.
For the Direction property, type or select the direction in which the text is written.
For the Language property, type or select the language that you want to use for the text box. This value overrides the Language property for the Report.
For the NumeralLanguage property, type or select the format to use for numbers in the text box.
For the NumeralVariant property, type or select the variant of the format to use for numbers in the text box.
For the UnicodeBiDi property, select the level of bidirectional embedding to use in the text box.
Expression Uses in Reports (Report Builder and SSRS)
Solution Design Considerations for Multi-Lingual or Global Deployments (Reporting Services)