HP 3000 Manuals

HP ALLBASE/BRW Tutorial

The Report Data 

The data is the same as the data for the previous report.  That is, you
will use the contents of the TOYDB data sets CUSTOMERS, ORDERS,
ORDER-DETAILS, and PRODUCTS. The plan of the database TOYDB is shown in
the figure of the TOYDB database in Chapter 1.

All the data in TOYDB is described in the dictionary file, BRWDIC.PUB.

Sketch the Report 

The structure of this report is similar to that of the second report,
except that you need a report heading to introduce the report and tell
users what data they have selected.

The report is printed in ascending sales area order.  Within each sales
area the report is printed in ascending customer number order.  Within
each customer number the detail lines is printed in ascending order
number order.  The report can use the standard printer paper, paper
length, and page width.

The calculations required for this report are:

   *   total sales in each sales area

   *   total sales in all sales areas

   *   total value of each order

These have all been defined in the second report.

Here is a rough sketch of this report: 


            

MPE/iX 5.0 Documentation