Report Writer - Set a Range

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

 

Range Options - Set A Range Prompts

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

Example

 

More 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

Field #

Enter the line number, which is next to the field name that you want to set.

Description

Displays the field title.

Note:  You must tab out of the Field # field to see the Description.

Primary Range

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

Notes:

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

  • To set the From field to the lowest possible value, click Lowest in the drop-down list.

  • To set the To field to the highest possible value, click Highest in the drop-down list.

Primary Option

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.

Secondary Option

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] if the button is in focus.

To escape without making the change click Cancel, or press [ENTER] if the button is in focus.

Other Report Writer Topics