Choose Report Filters (Consolidation Reports)
Report Filters enable you to restrict the amount of data that is returned in a report based on various criteria.
Filters can be date-based (Date Filters) or field-specific (Advanced Filters).
How to Use Report Filters
Build and save the filter
1. Build a filter for the selected report using the options included in the sections below.
2. Click Save to save the filter settings.
Run the report and view filtered records
1. Click the Run Report button.
2. A Report Results window opens.
3. The Report Results window includes a list of filtered records.
4. Click the numbered (Seq) link to open a record.
Date Filters
You can specify up to two date/time-based intervals on which to filter data.
Date Filters restrict the data displayed in the report to records that exist within the specified date ranges.
All date fields are grouped in the select menu for the filter fields. This grouping includes Date Type custom questions.
To create a Date Filter
1. Begin with Interval #1.
2. In the first drop-down list, select a report parameter (e.g., Reg Date Created).
3. In the second drop-down list, select a pre-existing date-range to apply to that report parameter (for example, Future, Today, This Month, etc.).
4. Select Custom to define your own date range.
5. If you select Reg Date Created in the first list and Today in the second, the report includes only those registrations created on the day you run it.
6. If you selected Custom, enter the Start Date / Start Time and End Date / End Time.
7. Enter dates in MM/DD/YYYY format (or use the calendar).
8. Enter times in 24-hour format (HH:MM:SS).
9. Use U.S. Pacific Time.
To add a second date filter
1. Add a second date filter.
2. By default, Interval #2 begins with " AND ".
3. You may select " OR " instead.
4. Select a report parameter and a date range as you did for Interval #1.
Advanced Filters
This section enables you to set up and apply various logic rules with which you can filter data.
Advanced Filters enable you to create highly customized reports.
To create an Advanced Filter
1. Select the Column that you wish to use to filter data.
2. Select an Operator that specifies how the data field contents will be evaluated.
3. Use examples such as equals ( = ) or is not equal to ( <> ).
4. Review Details of operators available.
5. Specify a Value.
6. Enter an open-ended value in the text box (i.e., a text string such as "North Carolina" or "@certain.com.").
7. Enter the numeral 1 for "Yes".
8. Enter the numeral 0 for "No".
9. Click the Pick List icon when it shows to see a list of predefined values.
10. If you are using two or more Advanced Filters, select a statement connector from the drop-down list as the logic to join your filters.
Connector logic for two Advanced Filters
- If you select and between two filters, records are included only if both conditions are true.
- If you select or between two filters, records are included only if one or the other of the conditions is true.
- The )and( selection enables you to complete the grouping identified by the previous Advanced Filters, create another grouping of the subsequent Advanced Filters, and join these two groups with a logical and.
- Use the )and( selection when you wish to join groups that use or internally.
- The )or( selection enables you to complete the grouping identified by the previous Advanced Filters, create another grouping of the subsequent Advanced Filters, and join these two groups with a logical or.
- Use the )or( selection when you wish to join groups that use and internally.
Example
| Condition A | and | Condition B | and | Condition C | and | Condition D | – | } | No need for grouping |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Condition A | or | Condition B | or | Condition C | or | Condition D | – | | |
| | | | | | | | | | |
| (Condition A | and | Condition B) | or | ( Condition C and Condition D ) | – | } | Grouping required to produce the desired results | | |
| (Condition A | or | Condition B) | and | ( Condition C or Condition D ) | | | – | | |