Wednesday, February 4, 2015

Cascaded Parameters in SQL Server Reporting Services

You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter.  

Let's understand with a simple example; suppose you have two parameters: ProductCategory and Product. When you choose the ProductCategory then the Product parameter lists only those Products which belong to the selected ProductCategory

How can we create cascaded parameters in SQL Server Reporting Services?

Read complete article here!

No comments: