Thanks for your input, guys:
Mr. Gale, I'm not sure I'm following. I'm using a stored proc for the dataset. Are you saying to modify the proc to have a table variable for the final data output of the proc? I'm not sure how that helps. (I may be missing something)
Mr. Williams, I'm trying to use the filtering in the table. The dataset returns all data since I'm using all data in other parts of the report; just this one table has to filter to reflect multiple values. I'm trying to apply the table filter with the switch code but I don't see how the switch function allows for multiple options in the result.
If parameter = 1, I just want the table to show data for "A" or "B" (It's this "or" part that I'm stuck on since Switch doesn't do "or" in this part of the function.) I could do "If parameter IN (1, 2) ,...." but that's not what I'm looking for here, and there doesn't seem to be an "IN" option (or an "OR" option) in the second part of the switch statement.
I can't think of any other way to filter the data, just for that table, to be either options when a specific parameter is selected.
Essentially the table needs to always display "B", but also whatever the parameter specifies, A, or C, or D, etc.
Does that clarify anything or did I just muddy the waters further?