Passing params value by a query to multiselect param of report through Data driven subscription

Hi Nilima,

For a MultiValue parameter, it is actual an Array data type. We need to pass an array value for it. However, so far, there is no array data type in current SQL Server versions. It means, it is still unable to pass values got from SQL Server to MutliValue parameter through report manager.

The solution to make it works is using SQL Server Reporting Service(SSRS) SOAP API.

http://social.technet.microsoft.com/Forums/sqlserver/en-US/bb9d31f7-8e4e-4d52-8696-66556ce92e15/ssrs-2005-webservice-programatic-multiple-parameters

We also have another workaround. It is using single value parameter instead of MultiValue parameter, and using Split function to split the string into array. Please see the following two articles for more detailed:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9ce92c7a-d136-46f7-85a2-1323ab242867/using-multivalued-paramters-with-datadriven-subscriptions

http://blogs.msdn.com/b/lukassteindl/archive/2013/04/19/data-driven-subscriptions-with-multi-value-parameters.aspx

Thanks,

Jinchun Chen

---

Jinchun Chen(JC)

TechNet Community Support