Setting a default for cascading parameters

Chuck Salerno 21 Reputation points
2021-02-26T16:33:59.623+00:00

I have 4 cascading parameters in a report. Need functionality for parameters 2 - 3 to set the default only if the number of selectable options are a single option in the dropdown. Otherwise use "-Select-" as the default. Is this possible?

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,853 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-03-01T08:20:44.147+00:00

    Hi @Chuck Salerno ,
    As far as I know, it does not seem to meet your needs in SSRS.
    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.


0 additional answers

Sort by: Most helpful