O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a cascading multivalued parameter

We may have noticed that the cascading functionality between the Category and Subcategory works only when we have a single category. If we select multiple Categories, we want to get all the Subcategories (multivalued) under those Categories.

We might think that setting up the @Subcategory parameter to "allow multiple values" would do the trick. But that won't work:

Creating a cascading multivalued parameter

I've seen people handle this requirement by using custom codes that are processed on the report server.

It's a good practice that anything that can be processed on the SQL Server database should be processed on the database.

With the use of the table-valued ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required