Multiple report parameters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Multiple report parameters

Multiple report parameters

Rate Topic

Display Mode

Topic Options

Author

Message

Trybbe

Posted Friday, May 08, 2009 3:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:24 AM
Points: 169, Visits: 440

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

Ramesh Saive

Posted Friday, May 08, 2009 3:44 AM

SSCrazy

Group: General Forum Members
Last Login: Saturday, June 01, 2013 4:52 AM
Points: 2,556, Visits: 2,590

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 »

Permissions