Filter a Report - Using Filter Logic

When adding more than one filter, the default logic between the filters is that they must all be true.  However, sometimes you may desire to have some filters true sometime.  To change the filter logic, use the [Filter Logic] field below the filter fields to reset the filter logic.  Here are some examples:

• Example 1: There are three filters. The objective is to have filters 1 and 2 be true at the same time or filter 3 is true.  This logic would be entered as:
  
  • (1 and 2) or 3
• Example 2: There are three filters. The objective is to have filters 1 or 2 be true and 3 is always true.  This logic would be entered as:
  
  • (1 or 2) and 3
• Example 3: There are four filters. The objective is to have filters 1 and 2 be true or 3 and 4 to be true.  This logic would be entered as:
  
  • (1 and 2) or (3 and 4)
    
• Example 4: There are three filters.  Filter logic is not set so the default logic is in effect.  This logic would look like this:
  • 1 and 2 and 3