Solved

SSRS Multi Selects

Posted on 2011-03-11
2
415 Views
Last Modified: 2012-05-11
How can you filter a second multi select control based on the choices of the first multi select on SSRS report? For example: The first control has options 1, 2 and 3 and valid relation for 1 = C. B or C and 2 would be D, E and F and 3 would be G, H and I. The user selects 1 and 3 the options for the second multi select control would be A, B, C, G, H and I

Thanks
0
Comment
Question by:raybar111
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 total points
ID: 35115549
What you're looking for is called "cascading parameters".  Here's an explanation on MSDN: http://msdn.microsoft.com/en-us/library/aa337169.aspx

Don't hesitate to ask further questions if something is not clear, I'll try to help you out.
0
 
LVL 16

Assisted Solution

by:Auric1983
Auric1983 earned 250 total points
ID: 35117088
The basics of a cascading parameter...
Let's say we had two parameters, Province and City. The first query would allow the user to select Province and the second would give you a list of cities for that province.

Query 1 : select * from Province

Query 2 : select City from CityTable where Province=@Province
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

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…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

911 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

18 Experts available now in Live!

Get 1:1 Help Now