Solved

SSRS 2008 Multi Value Parameter Filter using OR

Posted on 2016-11-11
3
40 Views
Last Modified: 2016-11-14
Hello experts -

I am trying to use a multi value parameter to filter two different fields in a tablix. However, SSRS does not allow me to specify OR when adding filters. For example, the user selects options in the multi valued parameter and then those choices are used to filter two different fields in an OR statement

Parameter: 'Choose Event Type:' [user selects] J, R

I want the tablix to return all rows with a Start Event of J, R OR all rows with an End Event of J, R

In the attached example, I would want rows 10, 24, and 25 to be returned.

I originally had one filter setup to use for both fields but abandoned that in favor of two fields, please see the attached screen shot of SSRS.

Thank you.

-- Lisa
SSRS-Multi-Value-Example.xlsx
Filters-in-SSRS.JPG
0
Comment
Question by:ldcallahan
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 41885347
You can't use an OR statement using the interface like you're suggesting, but you can still do it - it just requires you write the OR statement as a single filter condition and then check if it's a valid row inside the formula. If it is, you can set the "output" of your formula to 1 and then just have the filter check if the value is 1 before deciding to filter the row.

If that's confusing or doesn't make sense, I can add an example later.
0
 

Author Closing Comment

by:ldcallahan
ID: 41886263
Thanks. I actually realized that as well but am glad for the external validation :)

I actually ended up writing a split function that produces a table in SQL and then joining the result set to that. It works great and actually saves a bit of processing time.
0
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 41887290
I've done that as well - I wish there was a more graceful way to handle OR and multi-value parameters, but I'm glad you found a method that gets the job done!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question