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?