In our recent project, I’ve got a request to let custom reports to support multiple values in parameters. It seemed to be a little effort but I spent many hours to make it works.
Many recommendations advice to join the parameter’s multiple values in one using a function JOIN in SQL Reporting Services:
Then using Transact-SQL statement IN check if the variable of the SQL query is among the selected values.
Unfortunately, ‘as is’ it didn’t work for me.
Let’s customize the default SCCM report ‘Software 10B – Computers with a specific custom-labeled software title installed’. We want to let Label 1 has multiple values.
First, let’s save the report using a new name like ‘Software 10B – Computers with a specific custom-labeled software title installed (custom)’. Now we will make some changes.
Select Parameters, Tag1Name, Properties. Check Allow multiple values.
Read the rest here.