Forum Discussion

PowerDinosaur's avatar
PowerDinosaur
Frequent Visitor
4 years ago

Change Report Server language

Hi guys!   I would like to change the language of the Report Server from English. For example the language of buttons (like favourites, settings, etc..). I know that I can change the language of th...
Language
PBRS
Report Server
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi PowerDinosaur ,

language and Locale settings in the client browser determine the language resource used for report manager. For example, a user who uses a French version of IE to access a report server on a Japanese operating system, will work with French versions of Report Manager. But only the user interface components are affected by client language settings. The reports that you view and manage retain the language settings that were previously set for the report. 

Reference: Solution Design Considerations for Multi-Lingual or Global Deployments (Reporting Services)

Language

How is it used?

Report server language

The report server language is the language of the operating system on which the report server is installed. This language is determined by the regional settings of the computer.

The report server language is the language used by a report server instance for the following items:

  • Errors, warnings, and informational messages that are returned by the server.

  • Formatting in a report, if it is not otherwise set through the Language property in the report definition at design time.

  • Folder names for My Reports and Users folders that are created with the My Reports feature and that are visible to administrators. The My Reports folder is localized for users based on the client language settings.

  • Predefined roles and descriptions. Predefined roles include Browser, Content Manager, Publisher, Report Builder, My Reports, System User, and System Administrator. Names and descriptions for predefined roles appear in Report Manager and in other client tools that can be used to set report server permissions. These names are determined at installation, but you can use the Reporting Services Configuration tool to create a new report server database with a different language after installation.

There are currently ten SQL Server languages. The report server language for a given report server instance will always be one of the ten available languages. Support for all ten of the SQL Server languages is provided in a single Reporting Services installation. There are no language packs to install.

The report server language is set when you create the report server database. If you use the Reporting Services Configuration tool to create the database, you specify the report server language when you run the Change Database Wizard.

If you install Reporting Services in a default configuration, Setup determines the report server language when it creates the report server database. The language resource that Setup uses is the one that mostly closely matches the language of the operating system:

  • If an exact match between the operating system language and a SQL Server language is found, Setup will use the exact match. For example, if the operating system language is U.S. English, Setup will use the SQL Server language resource for U.S. English as the report server language.

  • If an exact match cannot be found, a close match will be used instead. For example, suppose the operating system is U.K. English. Because U.K English and U.S. English are in the same language family, Setup chooses the SQL Server language resource that most closely matches U.K English (in this case U.S. English).

  • If there is no close match available, the report server language will be U.S. English.

Client browser language

Language and Locale settings in the client browser determine the language resource used for:

  • Report Manager

  • Report Viewer toolbar

  • My Reports folder name

  • Localized elements of the report server folder hierarchy and report server content types, when the Report Server Web service is accessed through a browser window.

     

     

    Note
    Note that Reporting Services does not provide language conversion features. User-defined names for folders, reports, models, shared data sources, and resources appear in the language in which they were defined.

Report language

Reports use language settings for labels and formats:

  • Visual Studio labels are articulated in the language version of Visual Studio that you are using.

  • By default, formats for date, currency, and numbers are determined by the report server language at run time.

    To override the formatting provided through the report server language, you can set the Language property within the report when you design it. This can be set at the report level or the TextRun level. If you want to vary the formatting based on the language or local settings of the browser or client application, you can set the Language property to an expression that includes the User!Language variable.

Database language

Data that appears within a report is determined by the actual data values within the database and by database server collation settings.

SharePoint user interface

Language and Locale settings for the SharePoint user interface (UI) culture determine the language resources that are used for:

  • Reporting Services Web pages in the SharePoint site

  • Reporting Services Report Viewer Web part

.NET Framework language pack

When the .NET Framework language pack is installed, errors returned by the .NET Framework are returned based on client language and locale settings. These errors include Reporting Services errors displayed in the SharePoint UI and in Report Manager.

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien