Link to home
Start Free TrialLog in
Avatar of nolasaintsgal
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.
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial