Modify SSRS Parameter before report runs

Question

I wish to modify the SSRS parameter before the report runs.

-I have two parameters (A) a ComboBox and (B) a TextValue. -(B) changes values based on parameter A (cascades) but a user can type specific value for B too.

however the value of B is not what i want to submit to report stored procedure. I want to take the value of B and get another value from database, assign it to B and then pass it to my actual report stored procedure.

So is there any way to modify parameter before running report?

Answer 1

You can't modify the parameter in the way you are asking, however there is a way to achieve the result you want.

You need to create a third parameter, "C". The value of C should be set from another Dataset, which takes the value of parameter "B" and returns the value from the database. You then pass the value of parameter C to your stored procedure.

If you set parameter C to be "Internal" then this will be hidden from the user running the report and they will just set parameters A and B.