Share via

SSRS data driven subscription multi value parameter

Eshwar 216 Reputation points
2023-02-23T10:08:52.31+00:00

HI,

I am building a DDS for report with lot of parameters (with cascading parameters as well)

I need to map a multi value parameter values from a table (value is ID and label is text for that parameter definition), so tried passing 12323,121212 but it is not working as it is taking as one value.

Tried some googling but didnt get right answer!

Ex: Product group is parent parameter, Product is child parameter, trying to pass value for the child parameter from a custom table.

Appreciate your inputs.

Thanks,

Eshwar.

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,016 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft External Staff
    2023-02-24T07:43:39.1433333+00:00

    Hi @Eshwar

    It might not be particularly easy to use multi-valued parameters in data-driven subscriptions, and if you only have a small number of subscriptions, I recommend using standard subscriptions.3

    Of course, if you want to use data-driven subscriptions, I can find some solutions for you, you can refer to these links, use hidden parameters or use functions in the query.

    Passing multi valued parameters in Data Driven Subscription in SSRS

    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.