Open topic with navigation

Creating a Basic Filter

In the navigation pane of the Database Setup dialog, you can use the Filter node to create a basic filter to select the records that are printed at print time. When you use 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.

Supported filter criteria for the database connection include the following: 

ClosedTo create a filter

  1. Open the Database Setup dialog.

  2. In the navigation pane, click Filter to open the Filter property page.

  3. In the filter design area, click And, and then select the conditional joiner for the filter. For more information about conditional joiners, refer to Conditional Joiners Reference.

  4. Click to add a new filter condition.

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

  6. Click the Operator, and then select the conditional operator that you want to use. For more information about conditional operators, refer to Conditional Operators Reference.

  7. Click <enter a value>, and then select a value from the list on which to base your query. Alternatively, you can enter a value into the list box. You can now search by using only 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 are joined by the Conditional Joiner that you selected in step 3. To remove a filter condition, click .

  9. Click Apply Filter to view the results.

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

Examples

The following is an example of a single filter that searches for records in the database that have entries in the City field that equal "Fargo".

AND

City Equals Fargo

A joined filter uses a conditional joiner, such as "And" or "Or". The following is an example of a joined filter that searches for records in the database that have entries in the State field that equal "CA" and values in the Age field that are greater than "35".

AND

State Equals CA

Age Is greater than 35

The following is an example of a filter that searches for records in the database that have entries in the State field that equal "WA" or "CA".

OR

State Equals WA

State Equals CA

Related Topics