Open topic with navigation

There are several ways to filter data from a database for the purpose of specifying which records to print at print-time. Understanding how each method of filtering works will help you decide the best method to use for your printing requirements. Determining factors may include the data contained in your database, your printing needs for that data, and the print operators' level of search criteria knowledge or training.

In the Print dialog, you can opt to select queried records at print-time and filter the information that appears in the Select Records dialog. You can also filter records by using a Record Picker control on a data entry form.

In This Section

• Creating a Basic Filter

  By using the Database Setup dialog, you can create a static filter on one or more fields and/or tables of the database that you have connected to your BarTender document. This filter is applied each time you print the document, and only those records in the database that meet the filter criteria will be printed.

• Filtering Data Using a Query Prompt

  You can also use the Database Setup dialog to create a query prompt for filtering your data. The query (or filter) is created in the same manner as the basic filter, but instead of providing the criteria value in the saved filter, you create a prompt. At print-time the Query Prompt dialog is displayed, allowing the print operator to supply the filter criteria.

• Filtering Data Using the Select Records Dialog

  Using the search and filter features of the Select Records dialog, print operators can filter database records directly from the Print dialog or from a data entry form on which you've placed a record picker control.