HP 3000 Manuals

HP ALLBASE/BRW Tutorial

Exercise 5:Define the Sorts and Breaks 

This exercise describes how to define sorts, breaks, and pagination, and
how to suppress linesets.  It takes about 25 minutes. 

Define a break 

   1.  Choose  Define Breaks at the Define Report screen.

       The Define Breaks screen appears.


            

Look again at your rough sketch, shown on the next page.


            

The Lineset Notes column of the sketch show the linesets and breaks you
need.  The breaks on SALES-AREA and CUSTOMER-NO were already defined in
the report CUSTREP1, from which you copied the report for this lesson.
You still need to add the sort item, ORDER-NO, to print the details lines
in ascending numerical order.

Define a sort and break 

   1.  Add ORDER-NO in the Sort and Break on Item field below
       CUSTOMER-NO.

   2.  Type 3A in the Sort Level and Order field.  3A means that the item
       is a third-level (3) break and the sort will be in ascending (A)
       order.

   3.  Press Enter.

       This is how the screen will look:


            

       The message tells you that the breaks and pagination are modified.

Set pagination 

   1.  Look at the right side of the Define Breaks and Pagination screen.

   2.  Type 1 in the Reset Page Number on Level field.  This resets the
       page number to 1 every time a level 1 break occurs.

   3.  Type B in the Paging field for the Report Footing.  The B causes
       the new page to print before the report footing is printed.


            

   4.  Press Enter.

The message tells you that the breaks and pagination are modified.

Suppress linesets 

   1.  Choose  Suppress Lineset.  This prompt appears:

            Specify lineset level (D,P,R,1..9):  and type (H,F):

   2.  Type 2 in the lineset level field.

   3.  Type F in the (H,F) field.

   4.  Press Enter.

       The Suppress Lineset screen for the Break Level 2 Footing on
       CUSTOMER-NO appears.

   5.  Type this command on the first line of the blank area:

            ORDER-NO = NO_VALUE

       This means that if a customer has no orders, the footer for that
       break will not print.

   6.  Type this comment:

            << Suppress this lineset, which prints the total sales for the
            customer in the month,  if the customer has no order. >>

   7.  Press Enter.

       Your screen will look like this:


            

   8.  Choose  Exit to return to the Define Breaks and Pagination screen.

Suppress a detail line 

   1.  Choose  Suppress Lineset again.

   2.  At the prompt, type D (for detail) in the lineset level field.

   3.  Press Enter.

       The Suppress Lineset screen appears for the detail lineset.

   4.  Type this formula in the blank area of the screen:

            ORDER-NO = NO_VALUE

       Now, if a customer has no order, nothing will print on the detail
       line for that customer.

   5.  Type this comment:

            << Suppress this lineset, which prints the details of each order,
            if the customer has no orders. >>

   6.  Press Enter.

       Your screen should look like this:


            

       The message tells you the Suppress Lineset condition was added.

   7.  Choose  Exit to return to the Define Breaks screen.

MPE/iX 5.0 Documentation