HP 3000 Manuals

HP ALLBASE/BRW Tutorial

Exercise 1:Sketching the 1st Report 

Before you start to create a report, it is a good idea to have a rough
idea of its structure.  This exercise shows you a typical rough draft for
a report.  All you need to do is study the sketch so you understand the
report you will create.  This exercise takes 5 minutes. 

For example, the report for this tutorial needs a page heading, with the
report title, page number, date, and so on; a break heading to indicate
the start of a new sales area; a footing at the end of each sales area to
print the total sales for each area; one detail line per customer to show
each customer's number, name, and sales for the month; and a report
footing at the end of the report to print the total sales for all
customers, in all sales areas, for the month.

The following figure shows a rough sketch of the report you will create
in this tutorial.


            

The sketch shows that the report should be in ascending sales area order.
Within each sales area, the customer details should be in ascending
customer number order.  Therefore, the data must be sorted in ascending
order for sales area and customer number.  These two items, SALES-AREA
and CUSTOMER-NO are the sort items for your report.  (The term sort item
simply denotes that the item is used for sorting).  You can have up to
nine sort items, that is, nine levels of sorting in a report.

The only calculations required are total sales for each sales area and
total sales in all sales areas.  BRW will calculate these automatically.
The report can use the standard paper, page length, and page width.

MPE/iX 5.0 Documentation