May 25, 2011 at 8:28 am
Is there a way to show or hide a parameter in SSRS 2008 based on the value of a different parameter?
May 25, 2011 at 9:02 am
I started thinking out of the box and realized that I could populate a drop down list based on a parameter selection (we do that all of the time). So what I did was to create a custom SQL Query based on the value of the selected parameter (in my case the parameter is named Group). The query returns fields named ValueField and LabelField so I don't have to concern myself with different column names in the query. I created one Parameter named Selection and used the data set to get the values for the the list based on the selecton in the Group parameter.
On the report dataset query, I used a function for the value of the stored procedure parameter:
=IIF(Parameters!Group.Value = "Division", Parameters!Selection.Value, "Null")
on the second parameter:
=IIF(Parameters!Group.Value = "Failure Code", Parameters!Selection.Value, "Null")
Worked like a charm!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply