Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Multiple report parameters Expand / Collapse
Author
Message
Posted Friday, May 8, 2009 3:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 11:09 PM
Points: 176, Visits: 481
Hi

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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, October 21, 2013 12:32 AM
Points: 2,556, Visits: 2,593
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.


--Ramesh

Post #712756
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse