How to: Set the Locale for a Report or Text Box (Report Builder 2.0)

The Language property on a 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. For more information, see Using Built-in Field References in Expressions (Report Builder 2.0).

To set the locale for a report

  1. In Design view, click outside the report design surface to select the report.

  2. 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

  1. In Design view, select the text box to which you want to apply the locale settings.

  2. 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.