Share via

SSRS data-driven subscription parameter mutivalue

Angela 0 Reputation points
2023-02-07T05:35:52.7666667+00:00

Hi Support,

I'm creating a data-driven subscription on SSRS server, the report has a parameter called 'Branch', which use the below MDX query as the dataset.

How can I pass multiple branches to the report parameter from the subscription?

User's image

User's image

User's image

Angela

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-07T07:42:27.9033333+00:00

    Hi @Angela

    Based on my searches, it doesn't seem like an easy thing to do with multi-valued parameters in data-driven subscriptions.

    If you only have a small number of subscriptions, it may be better to manually set the multi-valued parameter values.

    But if you want to implement data-driven subscriptions, changing the default value or using delimited value strings may be the solution. I found these links for you, you can use them as a reference.

    https://www.sqlservercentral.com/blogs/ssrs-report-multi-value-parameter-going-after-data-driven-subscription

    https://wenleicao.github.io/Solving_SSRS_Multi-value_Parameter_Data_Driven_Subscription_Issue_Step_by_Step/

    Best regards,

    Aniya

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.