Answers.Body: <p>What you're asking isn't supported with CiviReport, unfortunately.</p>
  
  <p>You have a couple of alternative options:</p>
  
  <ul>
  <li>You can build a Smart Group that meets your criteria, then filter by the Smart Group.  However, I'm not sure what the current state of relative date filters and smart groups is these days, so this may not work.</li>
  <li>You can integrate a more advanced reporting engine like <a href="https://www.hitachivantara.com/en-us/products/big-data-integration-analytics.html" rel="nofollow noreferrer">Hitachi Vantara</a> or <a href="http://www.tableau.com" rel="nofollow noreferrer">Tableau</a>.</li>
  <li>If you're using Drupal as your CMS, you can build a View with CiviCRM integration to provide the report you need.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-14T19:52:02.433Z
Answers.Text: I also wanted to use OR and not AND in a report - see https://civicrm.stackexchange.com/questions/24637/how-to-report-on-repeating-custom-fields  Of course, Advanced Search can use OR so setting up a smart group as suggested by Jon G may work
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-14T13:21:41.913Z
Answers.LastActivityDate: 2018-05-14T13:21:41.913Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>How can I use the OR operator in a Participants report?
  I need a simple A OR B report, and I can only find how to do A AND B.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-13T16:30:23.653Z
Comments.Text: Run the report twice, once for A once for B, and combine in excel?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-13T17:29:08.907Z
Comments.Text: If it was me - no problem. But this report is run daily by the office people, and I don't want them to run 2 different reports, because the outcome of the report means the same for both conditions. I don't want to inflict my technical issue onto my end-users.
Comments.UserDisplayName: Elad
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-13T19:20:23.857Z
Comments.Text: If you're willing to write an extension you could make a copy of CRM/Report/Form/Event/ParticipantListing.php and in the where() function change the line (#603) where it ANDs the clauses together to an OR.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-13T20:09:36.853Z
Comments.Text: Could you please clarify your question?  Using the "Is One Of" filter allows you to select two values, and the presence of either will put them on the report.  While that answers the question as it's asked, I imagine you're asking something slightly different.
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-05-14T08:16:42.947Z
Comments.Text: I mean an OR based condition that is not just 1 value of a few options of the same field, but actually 2 composite conditions, with an OR between them. 
  Something like: If 'Arrival Date' (custom field a) is within the next 7 days OR ('Event Type' equals X AND 'Event Date' is within the next 7 days)
Comments.UserDisplayName: Elad
Tags: <civireport>
Title: OR operator in reports - How to draw a Participants report where A OR B?
ThreadText: # OR operator in reports - How to draw a Participants report where A OR B?
  
  (Asked by: username_0 on 2018-05-13)
  
  How can I use the OR operator in a Participants report?
  I need a simple A OR B report, and I can only find how to do A AND B.
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: Run the report twice, once for A once for B, and combine in excel?  
  > **username_0**: If it was me - no problem. But this report is run daily by the office people, and I don't want them to run 2 different reports, because the outcome of the report means the same for both conditions. I don't want to inflict my technical issue onto my end-users.  
  > **username_1**: If you're willing to write an extension you could make a copy of CRM/Report/Form/Event/ParticipantListing.php and in the where() function change the line (#603) where it ANDs the clauses together to an OR.  
  > **username_2**: Could you please clarify your question?  Using the "Is One Of" filter allows you to select two values, and the presence of either will put them on the report.  While that answers the question as it's asked, I imagine you're asking something slightly different.  
  > **username_0**: I mean an OR based condition that is not just 1 value of a few options of the same field, but actually 2 composite conditions, with an OR between them.  Something like: If 'Arrival Date' (custom field a) is within the next 7 days OR ('Event Type' equals X AND 'Event Date' is within the next 7 days)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-05-14. Score: 2 | Accepted answer
  
  What you're asking isn't supported with CiviReport, unfortunately.
  
  You have a couple of alternative options:
  
  * You can build a Smart Group that meets your criteria, then filter by the Smart Group. However, I'm not sure what the current state of relative date filters and smart groups is these days, so this may not work.
  * You can integrate a more advanced reporting engine like [Hitachi Vantara](https://www.hitachivantara.com/en-us/products/big-data-integration-analytics.html) or [Tableau](http://www.tableau.com).
  * If you're using Drupal as your CMS, you can build a View with CiviCRM integration to provide the report you need.
  
  > **Comments:**
  > **username_3**: I also wanted to use OR and not AND in a report - see https://civicrm.stackexchange.com/questions/24637/how-to-report-on-repeating-custom-fields  Of course, Advanced Search can use OR so setting up a smart group as suggested by Jon G may work  
  
  ---
  
  