Multiple report parameters

  • 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

  • 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