SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Displaying Multi-select Parameters in SSRS

Including the parameter values to the physical report so they get printed with the business data is a best practice and for good reason.  I have seen several printed reports that you could not tell the date ranges, products, etc... the report was ran for.

The Join function in SSRS will allow you to add multi-select parameter values to a report.  The syntax is rather simple as below.  The delimiter is option and if not used the default is a space.

=Join(Parameters!<parameter>.Label, <delimiter>)

If you have a parameter of say ProductBrand and wanted the values to be separated by a comma, the syntax that you would insert as the text box expression would be:

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

Marc Beacom  ...

Marc Beacom

Marc Beacom – MCTS (BI, Dev), Principal Architect and Owner at DawaBI, has over 15 years of technical and business experience. DawaBI focuses on Making Data-Driven Decisions Possible by delivering user friendly and scalable data warehouse and business intelligence solutions. Marc is an active volunteer within the community and currently is co-organizer of the Colorado GiveCamp, served a year as a PASS Regional Mentor and served five years on the leadership board for the Denver and Colorado Springs SQL Server User Groups.


No comments.

Leave a Comment

Please register or log in to leave a comment.