HP 3000 Manuals

HP ALLBASE/BRW Tutorial

Exercise 5:Defining the Sort and Breaks 

This exercise describes how to use parameters, how to use the standard
item SELECTION-SET in a condition, and how to suppress the page heading.
This exercise takes 20 minutes. 

You can use the sorts and breaks that you defined for the previous report
in this report.  However, you do not want to print the report footing
lineset when the report is compiled with selection set SALES-MANAGERS.

The Report Footing prints the total for all selected customers in all
sales areas, and it is a security requirement that sales managers do not
have access to this information.  Also, reports compiled with the
selection set SALES-MANAGERS can only access records from one sales area,
so the report footing would be misleading.

Define a new sort and break 

   1.  Choose  Define Breaks.

       BRW displays the Define Breaks & Pagination screen.


            

   2.  Choose  Suppress Lineset.

       BRW prompts for the lineset level, as shown in the next figure.


            

   3.  Type R in the lineset level field.

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

   5.  Press Enter.

       BRW displays the Suppress Lineset screen for the Report Footing.

       When the selection set is SALES-MANAGERS, you want to suppress the
       total for all areas.

   6.  Type the following text:

            SELECTION-SET = "SALES-MANAGERS"
            << Suppress this lineset, which prints the total sales for
               all selected customers in the month, if selection set is
               for sales managers. >>

       _________________________________________________________________ 

       NOTE  You must enter the value SALES-MANAGERS in uppercase
             letters, as shown.  BRW is case sensitive when information
             appears inside double quotation marks (").

       _________________________________________________________________ 

   7.  Press Enter.


            

       BRW tells you the Suppress Lineset condition was added.

       Now this lineset will be suppressed, that is, will not be printed,
       if the selection set with which the report was compiled is
       SALES-MANAGERS. Note the standard item SELECTION-SET used in the
       formula.  You can use this item anywhere in a report layout or in
       layout (but not table) calculations.  It holds the name of the
       selection set with which the report was compiled.

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

Absolute Positioning of Linesets 

For this report, you have a report heading that introduces the report and
prints the page number and date.  The report heading is printed at the
top of the first page of the report.  The page heading also prints the
page number and date and is normally printed at the top of every page of
the report.  Because the report heading already prints this information
on the first page, you do not need the page heading to print also.

You can set an absolute position for the report heading that will prevent
the page heading from printing.

If you specify that a lineset is to be printed at an absolute position on
the page, you will reserve the space on a page for that lineset.  Then,
whenever that lineset occurs it will start at the line you selected, and
any subsequent linesets will be printed after the absolutely positioned
lineset.

However, there is a special case with the page heading and footing.  If
you position a lineset absolutely on a line that is normally occupied by
the page heading or footing, the page heading or footing is suppressed.
So if you specify that the report heading lineset is printed on line 1,
the page heading will be suppressed when the report heading is printed.

Suppress page heading and footing 

   1.  Type A in the Paging field for the Report Break Heading.

   2.  Type 1 in the Abs field.

   3.  Press Enter.


            

BRW tells you that the Breaks and Pagination were modified.  The A in the
Paging field for the Report Headings will print a new page after the
introductory report heading.

MPE/iX 5.0 Documentation