Report Writer - Set a Range

The table below describes the prompts for the Report Writer Range button, which you can use to limit the selected records to a range of values for a specific field.

Report Writer Range Window Example:

Range Options - Range Prompts

Tip:  To see information about other Range Options buttons, refer to Report Writer - Range Options.

Field

To select a field to enter a range, click a choice in the drop-down list.

Range

Primary Range

Enter the From and To values to define the range of records you want to include or exclude from the report.

Note:  The values you enter must be valid values that exist in the file.

Range Examples:

    • Using only Primary Range:

    • Include: Lowest to 4567 (prints 1 through 4567)

    • Include: 5000 to 5999 (prints only 5000 through 5999)

    • Include: 4567 to Highest (prints 4567 through 9999999)

    • Exclude: 1000 to Highest (prints only 1 through 999)

    • Using both Primary and Secondary Ranges:  (prints 2000 through 5999, skipping 3000 through 4999)

    • Primary: Include 2000 to 2999
      Secondary: Include 5000 to 5999

Include/Exclude

Set the option as follows:

  • Include:  To include the records containing the range, select the box.

  • Exclude:  To exclude the records containing the range, de-select the box.

Secondary Range

Enter the From and To values to define the range of records you want to include or exclude from the report.

Note:  The values you enter must be valid values that exist in the file.

Include/Exclude

Set the option as follows:

  • Include:  To include the records containing the range, select the box.

  • Exclude:  To exclude the records containing the range, de-select the box.

To activate the new setting click OK, or press [ENTER].

Keyboard shortcut:  [ALT + o]

To escape without making the change click Cancel.

Keyboard shortcut:  [ALT + c]

Other Report Writer Topics