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.
SSRS
Last Comment
Nico Bontenbal
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
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.
ask a questionAll of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck