SQL - Pass Multi-value parameter from master to subreport

To pass a Multi-value parameter from a master to a subreport, first add the parameter in both reports. Only the parameter in the master report has to contain the values.

In the master report in the Subreport Properties section, make a connection between both parameters:

Be carefull: when adding the parameter, BIDS will add it as =Parameter!Opp_Stat.Value(0). Change this in =Parameter!Opp_Stat.Value because else you will only see the first parameter value in your query result!

Your datasource should look something like this:

One thing I think worth to emphasize, since it's a multi-valued parameter, the query in the Subreport 's Datasource has to use the "in" syntax and not the "=" syntax.

Original post: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/ae5ac615-1076-428d-9fcf-6c27e5fee1f0/