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.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.