nolasaintsgal
asked on
Filter dataset based on multivalue parameter
I have a multivalue parameter for 'area' that consists of five values:
Collections
Collections/Real Estate
Collections/Estates
Corporate
Corporate/By-laws
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.
Collections
Collections/Real Estate
Collections/Estates
Corporate
Corporate/By-laws
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.