The Search field and filtering tools may not be available on the data entry form, depending on how you have specified various properties of the Record Picker data entry control.
Filtering Data Using the Select Records Dialog |
The Select Records dialog displays database records in a table format and enables you to search and filter on the available records and subsequently select the records that you want to print. You can access the dialog by using one of the following methods:
On the Print dialog's Quantity tab, click Select Records. By default, this view displays columns for each database field that is linked to an object on the template.
When a data entry form contains a Record Picker control, it appears as an embedded Select Records dialog. By default, this view displays columns for each database field, unless it is configured to do otherwise by using the control's Columns property page.
You can apply a simple filter to the records in the dialog by using the Search field, which is located at the top of the table. As you type into the Search field, the characters that you enter are used to filter the records in the table. When you are done entering characters, only those records that contain values that match the search characters (in any of their columns) are displayed in the dialog. When the results are displayed, click to select the check box to the left of the field name to select that record to print. You can select some, all, or none of the search results.
In addition to the Search field, the Select Records dialog provides various filtering tools.
|
|
The Search field and filtering tools may not be available on the data entry form, depending on how you have specified various properties of the Record Picker data entry control. |
Use the Filter button to quickly filter the records based on any value within a selected field, or even filter to display those records that have no data for the field. The Filter button also enables you to open the Custom AutoFilter dialog, where you can create more complex filters.
Create a filter for a database field by using a complex expression with up to two conditional statements that can be based on one or more of the database fields.
Learn how to use the Custom AutoFilter dialog to create a custom filter.
Use the Filter Editor dialog to create a custom filter by using a complex expression with one or more conditional statements.
Use the AutoFilter Row tool to quickly filter the database records on any database field that is displayed in the Select Records dialog.