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.

Assume that you apply the update that is described in Microsoft Knowledge Base (KB) article 2677070 on a computer that is running Microsoft SQL Server Reporting Services (SSRS). When you try to start SSRS, you receive a time-out error, and event ID 7000 and event ID 7009 are logged in the Application log.