• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 428
  • Last Modified:

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
0
raybar111
Asked:
raybar111
2 Solutions
 
ValentinoVBI 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
 
Auric1983Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now