I have a multivalue parameter for 'area' that consists of five values:
If the user chooses 'Collections' and 'Corporate/By-laws' then the dataset should return records where 'area' like 'Collections%' and records where area= 'Corporate/By-laws'. The idea is for a user not to have to pick every value that begins with Collections because in reality they have a bunch of them, but be able to get them all if they choose 'Collections.' They still however will occasionally want to see only a specific value so might check just 'Corporate/By-laws'.
The dataset is created from a stored procedure that I'd rather not have to edit and if I did have to edit, then I'd have to figure out how to pass it a multivalue parameter and then the sql that would do what the filter should do.
Any insight would be appreciated. thanks.