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