Solved

Cascading Parameters in Report Builder 3.0 working with a Model

Posted on 2014-03-04
2
1,190 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 39

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now