One of the readers asked me this question in Ask Sherry Li
Dependent parameter in SSRS
How do I create a dependent parameter in SSRS? For example, select a Supervisor in the first drop down and then the Employees for that Supervisor appear in the second drop down.
Master Skills of Manipulating Report Parameters
Before I answer the question, I’d like to draw your attentions to skills report developers need to master.
Building interactive SQL Server Reporting Services reports not only require report developers to master skills of using parameters, but also manipulating report parameters in many different ways. Here are some of the ways we can manipulate the report parameters:
I’ll blog about the Steps to Create Cascading Parameters in the next post.
Tags: #SQLServer, SQL Server, SSRS EXPERT, BI, brh,