Setting the Report Language Parameter in a URL

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 the report server is set to a regional setting of German, but a user is accessing a report via a URL using a browser that is set to English-United States, parameter values that are passed to a report server will be misinterpreted.

Consider the following URL to a report:

https://localhost/Reportserver?/SampleReports/Product+Line+Sales&rs:Command=Render&StartDate=4/10/2003&EndDate=11/10/2003

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 by a start date of October 4, 2003 and an end date of October 11, 2003 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, 2003 and November 10, 2003 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://localhost/Reportserver?/SampleReports/Product+Line+Sales&rs:Command=Render&StartDate=4/10/2003&EndDate=11/10/2003&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 parameters area of the HTML viewer is collapsed out of sight, but can still be toggled by the user. A value of false completely removes the parameters area from the HTML viewer toolbar and makes it unavailable to the end-user.

See Also

Reference

Using URL Access Parameters

Other Resources

URL Access

Help and Information

Getting SQL Server 2005 Assistance