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:
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 ...