Customizable Parameter Prompt Value in SSRS
Currently, there is no way in SSRS to customize the pompt value for the parameter. This means, at the design time, the developer has to type the prompt value for the parameter. Currently this is not data driven, nor it can be changed thru a .NET assembly code.
This is a problem where a single report has to be accessed by users who speak multiple languages, for them the prompt value has to be translated and also adjusted to the user culture.
examples for Prompt values are "Select Country", "Select Users", "Select Model"
The drop down values associated to the parameters can be configured as they can be query driven, unfortunately the prompt is not.
Upvotes: 37<=-=May 3 2007 4:26PM=-=>
Thank you for requesting this feature. We will consider this in the next release of Reporting Services.<=-=May 4 2007 9:57AM=-=>
Thank you for requesting this feature. We will consider this in the next release of Reporting Services.<=-=Nov 1 2007 7:45AM=-=>
This is incredibly important for localizing report parameter prompts. Right now we can localize everything except report parameter prompts. This means we’re having to write our own code to do all the parameters. Which means we’re starting to look seriously at other tools that have a better API.<=-=Nov 29 2012 7:20AM=-=>
This keeps SSRS from being used as a platform for an application. Equally important is the ability to parameterize the fields for a dataset. I can write code for the query but then have to specify what fields are being pulled – boo!<=-=Apr 10 2013 8:04AM=-=>
SQL Server Reporting Services is a great and powerful tool. We will really like the feature that can be used to automatically get the parameter label from either a dataset or from a resource (.dll) file.
We have a application for healthcare and we have customers in USA, Europe, Asia, Africa and South America. All of our products are localized except reports (reports are partially localized)
We’ve localized every aspect of the report accept Parameter Label.
We would also like to have a dynamic caption of the parameter label in Available Values. Currently we can get the list of available values from the database, but it will be helpful if we can have an option to get the label caption for available values from resource (.dll)<=-=Aug 27 2014 1:42AM=-=>
I am facing same issue with 2008R2. have you guys found any promising solution for it.<=-=Dec 6 2017 7:01PM=-=>
Even with the major update in SSRS 2016, this still can’t be done. Microsoft, can you please consider adding this behavior? It seems like the Prompt text would be fairly easy to attach to an expression similarly to what can be done with many other SSRS properties.
Björn Lok commented
As the previous comment suggested, it can not be that hard to add an expression box ("fx") next to the parameter prompt field so that it would be possible to use a public function in the report code for localization purposes.