HP 3000 Manuals

HP ALLBASE/4GL Developer Reference Manual Vol. 1

Selection Criteria Screen 

This screen allows you to define optional criteria for selecting records
from the primary report file or link files for reporting.  The report
generator sets the switch *BYPASS on if a record read from the file fails
the selection criteria.  If *BYPASS is on, the report generator does not
print the contents of the record.

Screen Image 


            

Field Descriptions 

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

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

After Selection Function   Enter the name of the function that is
executed after the report generator has tested the record read from the
file against the selection criteria.  You can use this function to
perform additional selection or checking.

The function has access to each record as the report generator reads it
from the file.  The function can also test the status of *BYPASS after
the record has been tested.  You can use this function to accept rejected
records, or reject accepted records by setting the value of *BYPASS
appropriately.

Selection Number   Enter a number between 1 and 99 to identify this
selection.  The selection number does not impose any sequence of
resolution of the selection criteria.  If you are defining a new set of
selection criteria, the display in this field becomes the number of the
next available selection, even if you enter a larger number.

Action   Enter the code of the action to be performed on this selection.
The action can be any one of the following:

 A   add new selection

 C   change this selection

 I   insert a new selection before this one

 D   delete this selection

Link   Enter 0 to specify that the selection applies to a field on the
primary report file.

Enter a number in the range 1 to 999 to specify the link number to which
this selection applies.  The link number must be defined on the file
linkages screen.

Link File [.record]   A display-only field that shows the file (and
record) on which this selection criteria operates, as defined on the file
linkages screen.

Field Spec.  Name   Enter the name of a field in the previously specified
file (and record).  Enter the dictionary field specification name only,
without the name of the file and record.

Selection Criteria:  Values FROM   Enter one of the following containing
the starting value of the range acceptable for the field:

   *   Integer number.

   *   Literal.

   *   Numeric or alphanumeric constant.

   *   Variable or calculated item.

   *   Screen field reference.

   *   Scratch-pad field reference.

   *   File record field reference.

   *   Work area field reference.

   *   Communication area field.

   *   *RANGE = range_name.

   *   *TABLE = table_name.

If you specify a range_name or table_name, you must use a validation
table or validation range name that has been defined on the appropriate
dictionary screen.

You cannot use substring references in this field.

Selection Criteria:  Values TO   Enter the ending value of the range of
acceptable values for the field.  You can specify any of the values
allowed for the values from field except *RANGE= and *TABLE=.

Leave this field blank if you have specified a validation range or table
name in the values from field.

Function Keys 

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

f2       Sorting  Cancels the current screen and displays the report
        sorting screen.

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

f4       Generate Report  Generates the report.

Additional Information 

The report generator allows you to specify up to 99 selection criteria
per report.  If you don't specify any selection criteria, the report
generator reports every record in the primary report file.

If you specify more than one selection criteria for a record, (for
example, selection on two different fields in the same record) the report
generator only reports the record if all selection criteria are
satisfied.

If you define selection criteria for a link file, the report generator
only prints the link print line group or groups if all the selection
criteria on the link records are satisfied.

If you define one or more critical links from any particular report line
group, and you specify selection criteria for these linkages, the
initiating report line group is only printed if all the link files
contain records that pass selection.  If all the link files do not
contain records that pass selection, the report generator sets the switch
*ENDLINE on and does not print the line group that initiated the
linkages.

The selection criteria for link files are only defined for one file
linkage, which in turn is only defined for one report line group.  If you
have more than one linkage defined for a link file (that is, links to the
same file are defined for more than one report line group) you must
specify selection criteria separately for each linkage.  The selection
criteria do not need to be the same for different linkages to the same
file.

MPE/iX 5.0 Documentation