I have a parameter in my report called vendorID. It's data type is Text. It allows multiple values. I have specified 6 values as such:
Label Value
Vendor1 1
Vendor2 2
Vendor3 3
Vendor4 4
Vendor5 5
Vendor6 6
My query works fine when I select one or multiple of these values. It also works fine if I select the (Select All) value. What I would like to do is combine some of them into a group. Say I want to put Vendor1 and Vendor3 in a group called InState. I have tried adding a parameter value like this:
Label Value
InState 1,3
But that does not work. Does anyone know a way to make this work? Or a better method to accomplish the same type of task?
Thanks!