Need a little advice on a report I'm trying to finish up. I would like to add a parameter where based on the dropdown selection, to add an "AND" operator to the Where clause. I will give an example.
Choice 1 "xid=1"
Choice 2 "xid=2 AND jtype=123"
Choice 3 "xid=4 AND jtype=456"
I tried to add them as available values to a Parameter @Type, but doesn't seem to work, or I don't have the right expression. Or maybe I need a variable?
So, I would put in the main source query Where this=that AND @Type
How is the above possible. Please give steps. THanks in advance for your help!