Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Multiple report parameters Expand / Collapse
Posted Friday, May 8, 2009 3:11 AM


Group: General Forum Members
Last Login: Monday, August 4, 2014 11:24 PM
Points: 176, Visits: 482

I'm using SSRS 2005, Is it possible to have parameters that are dependant on other parameters?

In my report I have the following parameters: @StartDate, @EndDate, @Region (Multi value). Now I would like to add the fourth parameter which would only be acive after the user has selected a region.

Can someone please tell me how I can achieve that

Kind Regards
Post #712736
Posted Friday, May 8, 2009 3:44 AM


Group: General Forum Members
Last Login: Tuesday, June 7, 2016 5:15 AM
Points: 2,562, Visits: 2,643
1. Create a dataset to populate the fourth parameter
2. This dataset must include the dependent parameters (i.e. Region) as filter or where clauses
3. Create a new report parameter and select the newly created dataset in the "Available Values" section and select the key-value pair columns from the same section.

That's it, now you should able to see the values in 4th parameter only after selecting a value in the region filter.


Post #712756
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse