Good practice for creating reports in Reporting Services is to print state of parameters used in report. In that way if you see report printed or exported into Excel you are sure what data you have in front of you.
The easiest way, is to put it into header with report name automatically created by report wizard.
- Right click on header and select „Create placeholder”
- In properties click fx near „value” field.
- Select parameters, double click on parameter name, and it will create expression:
- It will create placeholder in header:
and it will be evaluated by Reporting Services to parameter value.
Reporting services report parameters which allow multiple values?
You can allow multiple values for parameter. It is defined in parameter properties:
I looks like:
But you can’t print this parameter values in report as described above.
You need different placeholder expression:
It will be evaluated by Reporting Services as a nice list:
Second parameter for Join function is delimeter. So you can split values by for example slash instead of coma.
Final report header with placeholders for parameters will look like: