How to add A selected parameters in Report Preview and excel export in SSRS?

Question

i have created the ssrs report with parameters. Whatever parameters i am selecting in the dropdown i want to show that in Report Preview and excel export.

Can anyone please guide how to do that?

Answer 1

You can use textboxes and enter the parameters in the expression. For single-value parameters, use either

=Parameters!ReportParameter1.Label 

or

=Parameters!ReportParameter1.Value 

Parameters have a label and a value. For example you can have a user with User_Id (value) = 1 and Username (label) = Rajashri. So you use the appropriate one.

If you have multi-value parameters, you will need to use the Join function in order to turn them into a list.

Example :

=Join(Parameters!ReportParameter1.Label, ", ")

Answer 2

To show this information on Export, you’ll need to include it in your report somewhere.

The approach we have taken is to display this information at the bottom of the table (for example), by merging all the cells and listing the parameters used for the report