Solved

Cascading Parameters in Report Builder 3.0 working with a Model

Posted on 2014-03-04
2
1,236 Views
Last Modified: 2014-04-17
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.
0
Comment
Question by:jaisy99
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 39904169
"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
0
 
LVL 1

Author Comment

by:jaisy99
ID: 39904232
I should have included more detail.  I'm working with the reporting model and the query designer.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Syntax error with Dates where clause 10 50
how to just get time from a date 6 34
SQLCMD Syntax 2 16
Where is the Help Section? 8 29
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question