SSRS Multi Selects

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
raybar111Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
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
 
Auric1983Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.