I am using a multi-valued parameter in paginated reports and the report loads only if I select one value, when I select 2 or more or ALL, it doesnt work.

Nimisha Vernekar 126 Reputation points
2021-12-14T09:44:59.55+00:00

I am using DAX in my query designer and any help would be appreciated.

Thanks

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.
2,728 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
34,961 questions
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,561 Reputation points
    2021-12-15T07:03:43.737+00:00

    Hi @Nimisha Vernekar ,
    Although it is possible to use DAX to retrieve tabular data in SSRS reports and you could even add parameters to DAX queries. But usually the conventional method of adding parameters only works if you want to base your results on one value at a time.

    For more information about using multi-valued parameters, please refer to:
    Handling SSRS Multi-Valued Parameters in DAX Queries.
    SSRS Multivalue Parameters in DAX.

    I would recommend you to use sql server data source and TSQL statement query, because it makes things a lot easier. Please see: Add a multi-value parameter to a paginated report.
    Hope this helps.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.


0 additional answers

Sort by: Most helpful