May 8, 2009 at 3:11 am
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
May 8, 2009 at 3:44 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply