Filter Button

The Filter button, accessible from the Select Records dialog or the print-time Record Picker data entry control, appears in each of the table's column headers and allows you to filter the record set based on criteria you enter for a single field. To access the Filter button, move the cursor over the header of the column you want to filter, and allow the cursor to hover in this position until the Filter button appears. Click and the Filter button will display a dropdown list of the available filter options.

The list contains all of the values that are currently entered in records for the selected field and one or more of the following default values:

(All): Displays all records. When selected, any previous filter option you've chosen for this column from the dropdown list options is removed.
(Custom): Opens the Custom AutoFilter dialog, where you can create a filter for the column using a complex expression with up to two conditional statements.
(Blanks): Displays only records that have no value in that column.

Select the desired filter option. The record set will refresh to display only those records that meet the specified criteria. Check the boxes next to the records you want to print.

Once you have filtered contents in one column, you can refine your filter even further by selecting Filter button options on subsequent columns.

Related Topics