Exercise 2:Using the Tutorial Glossary [ HP ALLBASE/BRW Tutorial ] MPE/iX 5.0 Documentation
HP ALLBASE/BRW Tutorial
Exercise 2:Using the Tutorial Glossary
As you go through this tutorial, you will be introduced to new terms.
Most of these terms are defined in the glossary section of this manual.
This exercise takes 5 minutes.
For this exercise, read the following paragraphs. Some words are printed
in bold type and have additional information you can look up in the
glossary of this manual. The paragraphs and terms will help you
understand the rough sketch of the report described in Exercise 3.
What is a Break?
Normally, a break occurs when you want BRW to calculate totals, print
lines of text or totals at the footing for one set of records, and then
print a heading for the next set. A report can break whenever a sort
item changes.
For example, in this report, SALES-AREA is a sort item. When SALES-AREA
changes from EASTERN to NORTHERN, all the records for the EASTERN sales
area have been written. BRW totals the sales for sales area EASTERN and
prints it. Then BRW prints the heading for the sales area NORTHERN.
You can have up to nine breaks, or break levels, in a report, one for
each sort item. Break levels are discussed in more detail in the Define
Sort Breaks exercise.
What is a Lineset?
A lineset is a group of lines (minimum 1 line, maximum 999 lines) that
are treated as a whole and can be printed together. For example, the
lines printed for the footing and heading of a break are known as break
footing linesets and break heading linesets. The lines that are printed
at the top of a new page, normally the page number, date, report title,
and so on, are called the page heading lineset. BRW prints the page
heading lineset (unless you use a suppress condition) at the top of each
page of the report.
Other linesets include the report footing lineset and the detail lineset
which prints the details of the report. In the tutorial report, the
report footing lineset prints the total sales for all customers in all
sales areas and the detail lineset prints the customer's name, number,
and turnover for the month.
You can have a maximum of 9 sort items in a report and up to 23 linesets.
The layout for each lineset is created at a separate screen. When the
report is run, BRW combines each lineset layout into a single report
layout.
Applying What You Learned
The following paragraph describes the linesets for this report. Apply
what you learned about the new terms you read about and looked up in the
glossary to help you understand this description.
The Linesets for This Report
This report has five linesets, as described below.
1. The Page Heading lineset. This lineset prints the report title,
page, and date on the top of each page. For this simple report,
it also acts as the report heading.
2. The Level 1 Break Heading lineset, that is, the lineset that is
printed before each new sales area when the sort item SALES-AREA
changes. This lineset prints the sales area name and a line to
introduce the detail lineset.
3. The Detail lineset, that is, each record in the report. For this
report, the detail lineset contains each customer's name, number,
and turnover in the month.
4. The Level 1 Break Footing lineset, that is, the lineset that is
printed after the details for the last customer in the old sales
area, when the sort item SALES-AREA changes. This prints the
total monthly turnover for all the customers in the sales area.
5. The Report Footing lineset, that is, the total turnover for all
customers in all sales areas, printed at the end of the report.
Note that you only need one break level, that is, for the break on
SALES-AREA. Although you sort the report on CUSTOMER-NO, you do not need
to define break heading and footing linesets for that item because each
different customer number is printed on a separate detail line and
requires no heading or footing.
MPE/iX 5.0 Documentation