Cascading Parameters in Report Builder 3.0 working with a Model
Posted on 2014-03-04
I'm working with and I am limited to a reporting model.
I would like to make my available parameter drop down values dependent upon the selection in another parameter.
For instance if the first parameter is State and the user selects Texas, then the next parameter should only drop down available categories associated with Texas. Instead, it is currently displaying a drop down of all categories contained in the model.
I have found lots of web references to doing this outside of a model, but I'm limited to a model.
I have created three datasets
(1) Report fields
I created a parameter for state and set available fields to the state dataset.
I created a parameter for category and set available fields to the categories dataset.
Now I just don't know how to properly link the state and category parameters together in Report Builder 3.0.
Any suggestions are greatly appreciated.