Log in  \/ 
x
x
x
Register  \/ 
x

configuration

29
June
2015

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 IN statement check if the variable of the SQL query is among the selected values.

Unfortunately, 'as is' it didn’t work for me.

Written by: Marat Kuanyshev Categories: configuration, System Center 2012, System Center 2012 Configuration Manager, SCUTILS BLOG

This is the default dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the 'x' icon.