Setting a default for cascading parameters

Chuck Salerno 21 Reputation points

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

    Hi @Chuck Salerno ,
    As far as I know, it does not seem to meet your needs in SSRS.
    Best Regards,

    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