HP 3000 Manuals

HP ALLBASE/4GL Developer Self-Paced Training Guide

Defining Report Selection Criteria 

If you are developing the HP ALLBASE/SQL based application, you can turn
to Line Headers.  You do not require any record selection criteria
because this is performed by the SELECT command in the get_prod_opt SQL
logic block.

If you are developing the KSAM based application or the HP TurboIMAGE/iX
based application, read on.

In the product_range function, the user is requested to enter the range
of products to be included in the report.  This screen allows you to
specify the fields that are tested to determine if a record is to be
selected for reporting.

Menu 
Path 

To access the selection criteria screen: 

   1.  From the main menu, select the Reports option.

   2.  Choose Record Selection.

Screen Description 

The screen allows you to define up to 99 sets of criteria that must be
met for a record to be included on the report.  You can specify
selections for records from the primary report file or any link files
used in the report.


          Selection Criteria Screen 

To enter the field values: 

        Field                 Entry                         Explanation 

---------------------------------------------------------------------------------------

Report Name           prod_opt              This is the name of the report that you are
                                            defining.

After Selection       Leave this field      This is the name of the function that is to
Function              blank.                be executed after each record is read.

                                            HP ALLBASE/4GL sets the switch *BYPASS on 
                                            if the current record read from the file
                                            fails selection, or off if the record
                                            passes selection.  You can use this
                                            function to perform your own manual
                                            selection by changing the status of the
                                            *BYPASS switch.  You can use this screen to
                                            specify just an after selection function
                                            and carry out record selection entirely
                                            from within this function.

Selection Number      1                     This number identifies this set of
                                            selection criteria.

Action                Accept the default.   This is the standard action code indicating
                                            add, change, insert, or delete.

Link                  Leave this field      If the selection criteria is to be applied
                      blank.                to a link file, you must specify the link
                                            number in this field.  You will learn about
                                            defining links to other files soon.

                                            When you leave this field blank, the link
                                            file displayed in the next field is the
                                            primary data file product.  By default this
                                            set of selection criteria is applied to the
                                            primary report file.

          Table 11-0.  (cont.) 

        Field                 Entry                         Explanation 

---------------------------------------------------------------------------------------

Field Spec.Name       product_no            This is the name of the field that is
                                            tested by this set of selection criteria.
                                            The field must exist on the link file
                                            displayed in the previous field.

Values FROM           *S01                  This is the lower limit value of the field.
                                            In this case it is the first screen field
                                            of the product_range data screen.  The
                                            entry can be a number, a literal, a
                                            validation table, or range.  The HP 
                                            ALLBASE/4GL Developer Reference Manual 
                                            lists the possible field types that may be
                                            used.

Values TO             *S02                  This is the upper limit value of the field.
                                            In this case it is the second screen field
                                            of the product_range data screen.  The
                                            range specified by the upper and lower
                                            limits includes the FROM and TO values.

To complete the screen: 

   1.  Press the  Commit Data  function key to create the selection
       criteria.

MPE/iX 5.0 Documentation