Report Builder - Display selected parameters on report page

[rogerdea]

Hello

Is it possible to show parameter selections on a report builder paginated report?  e.g.  I have a list of years and as users could be printing out the report, is would be important to know the parameters selected on the report itself.

Is this possible?

Thanks

[rogerdea]

Thanks for the reply, I did as you suggested by entering =Parameters![DateTableYear].Value into a text box, but it's returning #error on the report.

My Parameter:

Any ideas why?  It correctly changes the text in the box to <<Expr>> so i know it's accepted the code.

Thanks

[jrunion2]

Use this instead---  replace "DateTableYear" with your parameter name and it'll display your chosen parameters in a text box, separated by commas.

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

[Jon-Heide]

Yes. In the body of the report, add a text box. 

In the textbox, set the expression to =Parameters![NameOfYourParameter].Value

That should show the selected value of the parameter within the body of the report. 

[jrunion2]

Use this instead---  replace "DateTableYear" with your parameter name and it'll display your chosen parameters in a text box, separated by commas.

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