Cascading Parameters in Report Builder 3.0 working with a Model

jaisy99
jaisy99 used Ask the Experts™
on
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
(2) States
(3) Categories

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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
"Lesson 4: Adding Cascading Parameters (Report Builder 2.0)"
http://technet.microsoft.com/en-us/library/dd255296(v=sql.100).aspx

"How to: Add Cascading Parameters to a Report (Report Builder 3.0 and SSRS)"
http://msdn.microsoft.com/en-us/library/dd255197(v=sql.105).aspx

Author

Commented:
I should have included more detail.  I'm working with the reporting model and the query designer.
Andrew SheltonApplication Consultant

Commented:
As you are working with a Model, browse to the Report Designer from your Categories Datatset put a Prompt on State, ensure the State Parameter runs before the Category one, when you then first run the report the Category parameter will be greyed out until you choose the state, choosing the state will then limit the Categories depending on your choice

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial