Choose Report Filters

Report Filters enable you to restrict the amount of data that is returned in a report based on various criteria.

As described below, filters can be:

date-based (Date Filters)
based on the values of pre-defined fields relevant to that report (Standard Filters)
generated dynamically at the time the report is run (Drill-Down Filters)
field-specific (Advanced Filters)

How to Use Report Filters

1. Build a filter for the selected report using the options in the sections below. 2. Click Save to save the filter settings.

To View Filtered Data

1. Click the Run Report button. 2. A Report Results window opens. 3. The Report Results window lists the 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, including 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 (for example, 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.), or select Custom to define your own date range. 4. If you select Custom, enter the Start Date / Start Time and End Date / End Time. 5. Enter dates in MM/DD/YYYY format (or use the calendar). 6. Enter times in 24-hour format (HH:MM:SS). 7. Use U.S. Pacific Time.

You can add a second date filter.

1. By default, the Interval #2 begins with "AND". 2. You may select "OR" instead. 3. Select a report parameter and a date range, as you did for Interval #1.

Standard Filters

You can select various Certain pre-designed Standard Filters with which to filter data.

Standard Filters restrict the data displayed in the report to records that match commonly selected parameters.

The Standard Filters that are available to you depend upon the report type.

Example 1: A Registrations report includes Standard Registration Filters such as Complete being [Any], Yes, or No.

Example 2: A Charges report includes Standard Registration Filters plus Standard Charge Filters such as Transaction Type.

To utilize one or more Standard Filters:

1. Choose the Standard Filters that match your needs by selecting from the corresponding drop-down list(s). 2. The default values for all Standard Filters is [Any], meaning "any value". 3. Selecting [Any] provides the most inclusive results, since no filter is applied.

Drill-Down Filters

This section enables you to view different subsets of report results when the report is run.

For instance, a report that includes the parameter Registration Status can display registrations with status=Attended. Other times the report can display registrations that have the status=Cancelled. Using a Drill-Down Filter can switch quickly and easily between these two views.

To utilize one or more Drill-Down Filters:

1. From a Drill-Down drop-down list, select the report parameter that has the subset results you want to view. 2. This parameter is one that has been designated as a column in that report (for example, Status). 3. The columns that are available to use as Drill-Down Filters depend upon the report type. 4. For example, the columns available for a Registrations report include Complete, Paid, Registered, Attendee Type, Attendee Type Type, Reg Status, and Status Type. 5. Run the report. 6. The Report Results window opens. 7. From the Drill-Down section on the Report Results page, select the results you want to view. 8. Click the Drill-Down button.

Advanced Filters

Here you can set up and apply logic rules with which to filter data.

These Advanced Filters enable you to create highly customized reports.

You may create up to ten advanced filters on any report.

You may select numeric values in the advanced filters. You must use the Date Filters above to filter on date fields.

To create an Advanced Filter:

1. Select the Column that you wish to use to filter data. 2. Select an Operator. 3. The Operator specifies how the data field contents will be evaluated. 4. For example, equals ( = ) or is not equal to ( <> ). 5. Details of operators available. 6. Specify a Value. 7. You can enter an open-ended value in the text box as a text string such as "North Carolina" or "@certain.com". 8. For "Yes", enter the numeral 1; for "No", enter the numeral 0). 9. Or, if shown, click the Pick List icon to select from 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.

If you select and between two filters, records will be included only if both conditions are true.
If you select or between two filters, records will be 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.

For 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 ) | | | – | | |

Comments

0 comments

Please sign in to leave a comment.