How to localise parameters text in SSRS (SQL Server Reporting Services)
Hi,
I have a report (*.rdl) which has a parameter named @UserId, and its text value (e.g. User in English). The Parameter text value (User) can be set in Prompt text field under Report Parameter Properties windows. The text value is used for report parameter on
the top of a reprot.
Possible soltuion
Option 1)
The .rdl file is consumed by ASP.NET Web form ReportViewer. Thus, is it possible that the ReportViewer allows to change the parameter values programmatically.
Option 2)
What about change the parameter text on .rdl file directly programmatically.
Settings
SQL Server 2008 R2
Any idea would be very much appreciated!
June 22nd, 2011 6:09pm
Hi Kingofwebguru,
According to your description, you would like to localize the report parameter pane programmatically in reporting services, right? Please correct me if my understanding is wrong.
We cannot customize the parameter pane programmatically in reporting services. Just as you said, we can use ReportViewer in web application to reach your goal, for more details about how to use ReportViewer control with parameter programmatically, please refer
to the Visual Studio Report Controls forum:
http://social.msdn.microsoft.com/forums/en-US/vsreportcontrols/threads/, there are many experts
focus on it.
Moreover, this is a known issue in reporting services, you can refer to the following link, vote it is as important and hope Microsoft
improve this feature in the next service pack or product release.
Allow SSRS Parameter Panel to be formatted:
http://connect.microsoft.com/SQLServer/feedback/details/545893/allow-ssrs-parameter-panel-to-be-formatted
If you have any question, please feel free to ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 10:56am