HP 3000 Manuals

Defining a Report [ HP ALLBASE/4GL Developer Reference Manual Vol. 1 ] MPE/iX 5.0 Documentation


HP ALLBASE/4GL Developer Reference Manual Vol. 1

Defining a Report 

The following paragraphs summarize the procedure for defining a report.
Defining a report involves the following steps.

   *   Complete the report header screen.  This screen allows you to:

              - assign a name to the report.

              - name the output formal file designator.

              - specify the

                     primary report file.

                     report destination.

                     type of stationery for the report.

                     physical page parameters for the report.

                     names of the start-of-report and end-of-report
                     functions (optional).

              - enter a description of the report for documentation
              purposes.

   *   Define the report sorting fields.  This step is optional.
       However, if you want to sort the records that are read from the
       primary file or define control breaks to print subtotal and
       subheading lines in the report, you must define sort fields for
       the report.  The report sorting screen allows you to name the
       fields in the primary report file that are used for sorting
       records before printing.  The order in which you define the sort
       fields defines the sort levels and control break levels for the
       report.

   *   Define the report selection criteria.  This step is also optional,
       and generally only applies to reports that use HP TurboIMAGE/iX
       data sets, KSAM data files, or serial files.  Record selection for
       reports that use HP ALLBASE/SQL tables is usually performed using
       a SELECT statement.  If you don't define any selection criteria,
       the report generator reports on every record read from the primary
       report file.  The selection criteria screen allows you to specify
       selection criteria for fields on the primary report file.  You can
       also use this screen to specify selection criteria for records
       read from link files.

   *   Define the report lines.  You must use the report line header
       screen to define the lines that make up each line group.  The
       report line header screen allows you to define the characteristics
       of each report line.  This screen also allows you to define the
       before-print and after-print line spacing and name the
       before-print and after-print functions.

   *   Define the report linkages.  This step is also optional.  If you
       want to read information from KSAM data files or HP TurboIMAGE/iX
       data sets other than the primary report file, you can specify a
       file linkage to read the information.  Linkages are defined on a
       line group basis.  You can use the information read from the link
       file in all lines in the initiating line group, or you can print
       records from the link file in link print line groups.

   *   Paint the report lines.  The report line painter allows you to
       determine the layout of each report line as it will appear on the
       printed page.  All report lines (except lines in type C line
       groups) can consist of fields and literals.  The report line
       painter allows you to define the literals and the contents of each
       field that make up the report line.

   *   Generate the report.  You must generate a report before it can be
       executed.  To generate a report, press the  Generate Report  
       function key that is defined on the screens in the reports menu.
       You can also generate a report by selecting the Reports option on
       the application generation menu.  This menu is accessed by
       selecting the Generate option on the developer main menu.



MPE/iX 5.0 Documentation