Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cascading Parameters in Report Builder 3.0 working with a Model

Posted on 2014-03-04
2
Medium Priority
?
1,330 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 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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 to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

916 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