Program Definition

The Report setup utility REPSETUP will prompt you to make a series of selections:

• Tables

  You specify the lowest table in your table plan that you wish to access. The parent tables are automatically accessed through the keys on the table

  In the SALESORD table plan (See Data Dictionary Plan), the lowest table is the ORDER_LINE table. However, if your report is only concerned with customers and orders, such as a report on the balance of each customer, then you specify the ORDER_HEADER table

• Fields

  You can specify fields on the database, fields that are calculated at runtime, and fields that are entered by the user

  Fields are displayed in a column format. Report Writer will use the size of the field to automatically supply the position of the columns. Where there are too many fields to fit on the page, you can indicate where the output is to fold onto the next line

• Condition

  You can specify a condition to select records for reporting, exporting or deleting

• Totals

  For a report program, you can specify totals to be calculated for any numeric field

• Report Heading, Column Heading

  You can specify a heading that is displayed at the front of the report. DP4 automatically supplies the column headings using the field definition information on the database. The headings are printed with the date, time and page number at the top of each page of a report

• Sort

  You can sort the records by one or more fields. When sorting by multiple fields, you must choose their sort precedence

• Output Devices

  You can specify the default output devices for the program