Open topic with navigation

Creating a Basic Filter

In the Navigation Pane of the Database Setup dialog, you can create a basic filter to select records that will be printed at print-time by using the Filter node. With this basic filter, the print operator does not need to perform any additional tasks; when the print command is sent, the filter is automatically applied, and only those records that meet the filter criteria are displayed.

ClosedTo create a filter

  1. Open the Database Setup dialog.

  2. In the Navigation Pane, select Filter to open the Filter property page.

  3. In the Filter section, click And to select the conditional joiner that you want. For a list of available joiners, refer to Conditional Printing.

  4. Click to add a new filter condition. Alternatively, use the Insert or Plus Sign (+) key on your keyboard to add the new condition.

  5. Click the Database Field, and then select the field on which the filter criteria will be evaluated.

  6. Click the Operator, and then select the operator that you want to use.

  7. Click <enter a value>, and then select a value from the dropdown list on which to base your query. Alternatively, you can enter a value into the list box. You can now search by using just this filter condition, or you can add more conditions.

  8. If you want to add another filter condition, click , and then repeat steps 5-7. The filter conditions will be joined by the Conditional Joiner that you selected in step 3. To remove a filter condition, click .

  9. When you've finished adding conditions, click Apply Filter to view the results.

At any point, you can remove all of your filter conditions and start over by clicking the Clear Filter button.

Examples

A single filter that searches for records in the database that have entries in the City field that equal "Fargo" might resemble the following:

AND

City Equals Fargo

A joined filter uses a conditional joiner, such as "And" or "Or". A joined filter that searches for records in the database that have entries in the State fields that equal "CA" And values in the Age fields that are greater than "35" might resemble the following:

AND

State Equals CA

Age Is greater than 35

A filter that returns all records in which the "State" is "WA" OR "CA" might resemble the following:

OR

State Equals WA

State Equals CA

Related Topics