How to Pass Multi-Value Parameters to Data Driven Subscription in SSRS - Solved - SSRS Tips

How to pass multi-value parameters to DDS (data driven subscription). SSRS - Passing multiple value parameters in data driven subscriptions video show you how you can pass the multiple values to parameter in data Drive subscription in SQL server reporting Services. There is no straight forward way to handle that so I have used dynamic SQL and then use concatenated values for dataset of Data Drive Subscription.
Link for the script
www.techbrother...
MySQL Tutorial for Beginners
MySQL Development Tutorial
MySQL Tutorial for developers
MySQL Development Training
MySQL training for developers
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step

[@nazihjrg3540]

those experement are very useful and professional , keep on brother, thank you very mauch..

[@udayakoju07]

Hi Amer, can you help me, I created report with multi valued parameter, I created data set using SP and report was working fine & after deployment report ran successfully in report manager, I created subscription for my report as mentioned in this video but by running subscription throwing error, I verified data sources & log files also but unable to find the issue. But when I pass only single value in subscription it's working.

[@achyugonu]

check your code again and pass the parameter values properly

[@reemajiyani9160]

Same issue for me any suggestion?

[@reemajiyani9160]

Hello sir
I follow your video with one change you are passing dataset query for data driven subscription instead of this i create view for this query and pass select * viewname into data driven dataset query but report throwing error my value is not find. Can you please guide for this type of issue

I have a drop-down list in a parameter and all is one of them so when all is selected no data is displaying.. how can i fix it that issue

[@achyugonu]

great video

[@morrischung3036]

great video , but when I create a subscription why I don't see " Edit dataset " button

[@Shwaggggg]

on subscription type are you selecting data driven subscription? it defaults to standard subscription.

[@sashadongre]

Very nice video Sir