?
Solved

SSRS 2008 Multi Value Parameter Filter using OR

Posted on 2016-11-11
3
Medium Priority
?
96 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:Lisa Callahan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 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:Lisa Callahan
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

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