This is not a problem with multi-value parameters. The issue is when I pass more than one parameter, such as state and county. These are 2 different fields and if I alter the sql script to only require one or the other, the dds fires off correctly. It is when I use both parameters that it errors. So Long And Thanks For All The Fish!

I have an SSRS (2008 Reporting Services, 2008 R2 Sql Server) report that uses multivalued parameters. A function has been created to parse the comma separated values and is used on many reports currently. However, when I schedule my DDS and it fires, it always errors if I'm passing more than one parameter. In other words, if I pass, for example, the state, it works fine. If I pass only the county, it works fine. If I pass both state and county, it errors on the second parameter. Just be clear, the error happens when the subscription fires, not to the report. Any ideas?

Hi Goldballtx In DDS multi-value parameters are not supported, found some links for a workaround in the related topics though to the right. http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/630a6fa8-35d3-4b51-b2ae-a7b3e6557ea9/ http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/Best Wishes, The Redman; If something helps, please help show it by voting, if it solves, bonus!

Hi Golfballtx, In order to get a multi-value parameter in a Data-Driven Subscription, we need to define the multi-value parameter for the data-driven subscription programmatically by using the SOAP APIs. From your description, it seems that you have done this because the subscription works well when pass either of the two parameters. Then, the issue might be caused by the code you designed for multiple parameters. Here are a post and an article that include example codes for your reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/a39b57f4-e044-47d9-bced-962806d94634/ http://msdn.microsoft.com/en-us/library/aa225827(v=sql.80).aspx Hope this helps. Thanks, Mike Yin