I have a unique request from a customer, I am even having trouble to word it out in the subject. Anyway, I will try explain here and any insight is greatly appreciated.
Imaging I have the following records
John A .Net
John A C#
So on the report, the customer wants to see a list of people with selected skills. I used a multiple values parameter, Skill, with the options of .Net, C# and BA. Typically, if I select .Net and C#, It will return:
What the customer really wants is to return people with both skills, not either skill. (it's AND operator, not OR), really it should only return:
I don't think that's what multiple values parameter is meant to be, but any solution/insight/work-around is greatly welcomed.