| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Set the language for report parameters in a URL |
Learn how to set the language for report parameters in a URL by using the rs:ParameterLanguage URL access parameter. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
reporting-services |
how-to |
|
|
The rs:ParameterLanguage URL access parameter alleviates a problem in which culture-sensitive report parameters, such as dates, times, currency, and numbers, are interpreted using the browser language. With rs:ParameterLanguage, the URL is now interpreted independently of the browser. For example, if you set a report to a regional setting of German, but a user is accessing a report via a URL using a browser set to English-United States, the report server misinterprets parameter values passed to it.
Consider the following URL to a report:
https://myrshost/Reportserver?/SampleReports/Product+Line+Sales&rs:Command=Render&StartDate=4/10/2008&EndDate=11/10/2008
In the above case, the server, running under a culture of "de-de", generates a URL either through an e-mail subscription or a hyperlink. The hyperlink indicates that the report should be parameterized to a start date of October 4, 2008 and an end date of October 11, 2008 according to German date/time standards. However, a user that is accessing the URL through a browser set to "en-us" forces the server to interpret the values as April 10, 2008 and November 10, 2008 under United States English date/time standards. To fix the problem, rs:ParameterLanguage can be used to override the browser language for parameter interpretation:
https://myrshost/Reportserver?/SampleReports/Product+Line+Sales&rs:Command=Render&StartDate=4/10/2008&EndDate=11/10/2008&rs:ParameterLanguage=de-DE
In addition to a value of true and false for the URL access parameter rc:Parameters, you can now pass a value of Collapsed. When using rc:Parameters=Collapsed on a URL, the parameter prompt area of the HTML viewer is collapsed out of sight, but can still be toggled by the user. A value of false removes the parameter prompt area from the HTML viewer toolbar and makes it unavailable to the end-user.