HP 3000 Manuals

HP ALLBASE/4GL Developer Reference Manual Vol. 1

Report Sorting Screen 

This screen allows you to define the fields on the primary report file
used as sort fields, and to define the report sort order.

Screen Image 


            

Field Descriptions 

Report Name   Enter the name of a report defined on the report header
screen.

Secured   Display-only field indicating the status of the secured field
as defined on the report header screen.

Field Name and Order   These two fields define the fields on the primary
report file that are used for sorting records and their sorting order.
You can specify up to eight sort fields.  The sequence of definition of
the sort fields defines the sort levels.  Level 1 is the highest, or
primary, sort level and level 8 is the lowest sort level.

For each sort field, you must specify the field name and the order of
sorting.

Enter the dictionary field specification name of a field on the primary
report file in the Field Name field.  You can use subscript referencing
if needed, but you cannot use substring referencing.

Enter the sequence in which the field is to be sorted in the ORDER field.
The options are:

 A   ascending sequence (lowest to highest)

 D   descending sequence (highest to lowest)

The sort sequence used for each sort field depends on the edit code of
the field.  For numeric fields, the report generator sorts records in
numeric sequence.  For alphanumeric fields, the report generator sorts
records according to the system collating sequence (refer to appendix A).

The order and number of sort fields determines the order and number of
control break levels for the report.  A control break occurs when the
value in a sort field changes from one record to the next.  At each
control break, the report generator prints the subtotal line groups and
subheading line groups for the initiating control break and all lower
level control breaks (if they exist).  At control breaks, the report
generator prints subtotal line groups for the old value of the field
initiating the control break, and prints subheadings for the new value of
the field initiating the control break.

Is File already in Sequence?    If you enter Y, the report generator does
not perform any sorting on the file.  For KSAM data files, the report
generator reads the records in the sequence defined by the file index
specified on the report header screen.

For HP TurboIMAGE/iX data sets, the report generator reads the records
according to the sort order specified in the HP TurboIMAGE/iX schema
definition of the data set.  Refer to the HP TurboIMAGE/iX Database 
Management System Reference Manual for further details.

If you enter N, the report generator sorts records read from the primary
report file into the sequence determined by the sort fields specified on
this screen.

You must still specify the sort fields even if you do enter Y in this
field.  The report generator uses these fields to determine when a
control break occurs.

Function Keys 

f1       Header  Cancels the current screen and displays the report
        header screen.

f2       Record Select  Cancels the current screen and displays the
        selection criteria screen.

f3       Line Header  Cancels the current screen and displays the report
        line header screen.

f4       Generate Report  Generates the report.

MPE/iX 5.0 Documentation