Specifying Your Report with REPSETUP

When you run REPSETUP to create a Report Writer program you have two choices:

• For simple reports listing fields from one or more tables, use option 2 - Automatic program generation on the Edit menu of the initial REPSETUP screen

• To create a new report or edit an existing 1 use option 1 - Program editing. You can copy from an existing report using option 7 once you have selected a name for your new report. REPSETUP will not allow you to create a report which has the same name as an existing mapset. If you do do this the Creaet option will be greyed out when you have entered the report name.

• The stages involved in creating a report are as follows:

  1. Table details and type
  2. Heading
  3. Field processing
  4. List/delete condition
  5. Fast pass condition

  6. Output devices and format

Each of these Program editing options is briefly described in the following sections

• Table details and type

  Select the type of program to be created (REPORT, EXPORT, DELETE), choose the lowest table to be used for the program, fast pass table and sequencing table.

• Heading

  Add the report heading you want printed at the top of each page and specify the report width in characters.

• Field processing

  Select the fields to be processed by the program, including fields in the joined tables, fields that are calculated from formulas and fields that are entered by the user at run-time. A number of options are available to process fields, you may:

  • Total a field's value
  • Sort by the field
  • Choose whether to list the field on each detail line, or on/before break points
  • Choose whether to repeat the field's value when it is identical to that in the previous record
  • Start a new page or print a sub-total when the field's value changes
  • Fold the report output onto the next line after the field is printed
  • Change the formatting and spacing for the field

  • Conditionally total the field

• List/delete condition

  Specify the selection criteria that must be met for records to be included when reporting, exporting or deleting.

• Fast pass condition

  Specify a condition for record selection on the fast pass table if one is chosen.

• Output devices and Format

  Select the output device used by the program. Various print formats can be selected for different field types. You can:

  • Limit the number of records selected by specifying a range. The lower value of the range is called the Start value and the upper value is called the Stop value
  • Choose to pause after each page of output to the screen
  • Print a summary report comprising just sub-totals (without detail lines)
  • Suppress the standard page heading that includes the name of your company, database and program as well as the current date, time and page number