Customizing SCCM 2012 reports to support multiple values in a parameter

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:

=Join(Parameters!YourParameter.Value,’,’)

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.

screenshot1Read the rest here.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.