SSRS Report with Multi-value Parameter for use in Report Manager Portal and Subscription

Question

I am at my wits end on this one.

We have an existing report with multiple multi-value parameters that runs just fine via Report Manager Portal.

Now they want to set-up Subscriptions for this report and I cannot for the life of me get this to work.

I have tried with hidden parameters and tried attempting building the parameter list via a Data-Driven Subscription using a comma-delimited list and then parsing that with a function as I found via Google.

The subscription will just not work.

Can anyone PLEASE help me on this? PLEASE point me in the right direction via web sites or YouTubes as to how to make your multi-valued SSRS Parameter compatible with both Report Manager Portal and via a Data-Driven Subscription.

Answer 1

Hi @Bobby P ，
I'm not sure if your purpose is just to create a data-driven subscription? Have you tried to create a data-driven subscription before? Are there any error messages after the creation fails?

The data-driven subscription feature is not available in all versions. There are some restrictions on the types of data sources that can be used to retrieve subscription data at runtime. For more information about the SQL Server editions that support data-driven subscriptions, see SQL Server Reporting Services Features Supported by Each Edition.

Just create a data-driven subscription, you could refer to: Data-Driven subscription
Please also see these two tutorial：
http://datanrg.blogspot.com/2014/08/ssrs-report-multi-value-parameter-going.html
https://www.bigdatamark.com/ssrs-passing-multiple-value-parameters-in-data-driven-subscriptions/

If you have any question,please feel free to let me know.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Bobby P ,

Has your issue been resolved?

If you have any question, please feel free to let me know.

Best Regards，
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our [documentation][1] to enable e-mail notifications if you want to receive the related email notification for this thread.