Change report parameter default values dynamically
Is there a way to dynamically change the report parameter default values based on another report parameter selection I have more than one value as my default values. Is there a way to achieve this either using expressions or VB.Net code
December 14th, 2010 1:17am

Hi Lakshmi, Under default values, use non-queried option try adding expression=Parameters!param1.value. If it is textbox parameter definitely the value will not change since SSRS textbox refresh will not work. If it is DropDown parameter it will work.Nanda
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2010 1:38am

Hi Venkata, Thanks for the reply I want to have multiple default values Suppose I have report parameters A and B and A has values as 1, 2, 3 If I select 1, then B should have 10 default set of values If I select 2, then the default values will change and the same for option 3 I am using SSRS 2008 and the report parameters are of type text and multi value
December 14th, 2010 2:06am

This is possible using query dataset. 1. Create a dataset for Parameter B and pass parameter A values as query parameter. 2. In parameter B properties-> Available Values->, select 'Get values from a query' option and select the dataset. 3. Select the dataset for Default values also. In this way you can get all the default values selected for parameter B based upon parameter A selection. Please let me know if you have any questions.. Regards, Senthil
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2010 3:45am

Default values of a parameter can not be changed dynamically in SSRS as available values. I wanted to change default values of one parameter based on selection of another parameter This can be done for available values and can not be done for default values. Only on initial load, this will happen This was logged in Microsoft SSRS Connect
December 20th, 2010 6:46am

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

Other recent topics Other recent topics