Solved

SSRS 2008 Multi Value Parameter Filter using OR

Posted on 2016-11-11
3
79 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 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: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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

719 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