SSRS report

Question

We have a SSRS report with 4 parameters. The requirement is to remember/retain the last selected parameter values. All the parameters are multi-valued. Please advise Step by step how to do it.

Answer 1

Yes it is possible, even all the way back to SQL 2005 IIRC, you just have to think "kludge" and accept a clunky, inelegant way.

• Both available values and default values of a parameter can be queries
• Your "meat" query, best wrapped as stored procedure, can have side effects without your SSRS noticing, besides producing your rowset
• So you save the selection in a SQL table as side effect of the main query and fetch it in your parameter's source query for the parameter defaults...

Answer 2

The requirement is to remember/retain the last selected parameter values

In SSRS it's not possible.

Answer 3

Hi @Mantesh Golla

As far as I know, SSRS doesn't have this feature to automatically select a specific option or a set of options for the parameter dropdown list.

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Hi @Mantesh Golla ，
You might consider using Cascading Parameters.

For detailed tutorials, please see: Cascaded Parameters in SQL Server Reporting Services.

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.