SSRS 2008 R2: Refresh a parameter list after the report is generated

• TheComedian

  SSCrazy

  Points: 2932

  More actions

  May 2, 2014 at 1:35 am

  #290955

  Hi all,

  I was wondering whether it's possible to refresh a parameter list after the report is generated.

  Basically I have a textbox parameter, ParamTxtBox, and a drop down parameter, ParamDropDown. ParamTxtBox comes before ParamDropDown and the default value of ParamDropDown is set to ParamTxtBox.Label. After I change the value of ParamTxtBox and then click on View Report, a stored procedure, in the background, adds this value to a table, which is queried by ParamDropDown's data set.

  In order to see the new ParamTxtBox value in ParamDropDown, I have to close the report and reopen it. Is it possible for me to see this value right after I click on View Report?

• TheComedian

  SSCrazy

  Points: 2932

  More actions

  May 2, 2014 at 4:18 am

  #1710290

  Nevermind it appears this feature doesn't exist in SSRS http://social.msdn.microsoft.com/Forums/sqlserver/en-US/11eee199-7eb2-472e-b7da-76c25af62578/force-parameter-refresh-after-clicking-view-report?forum=sqlreportingservices