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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics