Forum Discussion

rogerdea's avatar
rogerdea
Icon for Helper IV rankHelper IV
3 years ago

Report Builder - Display selected parameters on report page

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 ...
Need Help
Tips and Tricks
Jon-Heide's avatar
Jon-Heide
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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's avatar
jrunion2
New Member
3 years ago

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, ", ")