Open topic with navigation

> Arrange information / Using criteria to query reports
In this section

Q: Using criteria to query reports

Criterion details

Enter criteria values

Using criteria to query reports

Introduction

Criteria control the information your report displays. Without them your report would display every piece of information that exists in the data it reads.

Unlike filters that always exclude information, with criteria you can select the range of information you want in your report; usually at the point when it is generated. For example, you may find you want to query your report to view a particular range of information between certain dates.

You can

Using criteria in reports

Add new criteria to a reportOpen this section

To add new criteria to a report:

  1. Choose Report > Criteria.
  2. Click New Criteria.
  3. Select the table and variable from your data that you want to set up the criteria for, then click OK.The Criterion Details window appears.
  4. Click OK to add the criteria to the report's criteria list.
  5. You can set the internal Criterion name, the criteria description (displayed when you preview the report), and set its Status to be enabled or disabled. See Criterion details.
Modify report criteriaOpen this section

To edit the report criteria:

  1. Choose Report > Criteria.

    Note: The list initially shows the active criteria for the report, that have a status of enabled or preset. To also see criteria that have a disabled status, select Show Disabled.

  2. Select the criteria you want to change then click Modify.
  3. You can set the internal Criterion name, the criteria description (displayed when you preview the report), and set its Status to be enabled or disabled. See Criterion details.
Change the order that criteria are displayedOpen this section

To change the order in which criteria are displayed when the report is previewed:

  1. Choose Report > Criteria.
  2. Select a criteria and change its position by clicking Move Up or Move Down.

Go to top