Field Criteria
- Matthew Garrett
The Field Criteria tab is used to select specific field criteria that will be used for report record selection. As the Standard Criteria dialog is based on an already established report, some criteria may already appear in the Required Criteria list (see below).
Selection of too many options may result in too few or no results on the report.
The Field Criteria tab is divided into four sections:
- Groups: Displays the available field criteria groups.
- Fields: Displays the fields available for a selected group.
- Required Criteria: Selected criteria that MUST be satisfied by the report results.
- Optional Criteria by Group: Selected criteria that may be satisfied by the report results. Up to ten optional criteria groups can be selected.
If using Optional Criteria By Group, more than one should be created. If there is only one selection, user's should place that criteria in the Required Criteria list.
To Add New Criteria to a Criteria List
Default criteria in the Required Criteria list can be modified by double-clicking on an item.
- From the Groups list, select the required criteria group. The Fields list will update.
- From the Fields list, select the required criteria.
Select the Required Criteria list or the Optional Criteria By Group list to select which list the criteria will be added to.
By default, selected field criteria will be automatically entered into the Required Criteria list unless the Optional Criteria by Group list is first selected.
Click the Add Criteria button (
). The Field Criteria dialog will be displayed. The type of dialog is determined by the data type of the selected field (Boolean, Number, Currency, Data, Time, String, or List).- Select the field criteria option(s).
- Click the OK button. The Field Criteria dialog will close and the new item of criteria will be displayed in the chosen list.