The report contains the 4 drill-down characteristics Customer group, Product group, Region and Division in that order. Note that the sort order for the printout (Report ® Print setup ® Drilldown and detail lists ® Mass print settings...) can differ from that of the displayed list (Navigate ® Sort characteristics). In this example, the sort order for the online list and the printout is the same.

1. The system starts by preparing the drill-down list broken down by Customer group.
2. Then the system "drills down" on the first row of that list (Customer group 1) to display the individual Product groups.
3. Then it drills down on the two product groups in this list (2 and 7) to display the individual Regions. The resulting lists are same two lists that would appear if you drilled down in that sequence online. The figure below shows these steps. Since the characteristic Region is the finest level of detail, the system does not go on to break the regions down by division.

The third drill-down level contains two drilldown lists broken down by region. The lines of these lists appear in order on the printout.

The totals for the individual product groups as well as for the first customer group are also displayed. The row with the total for Customer group 1 is followed by a page break, as was defined in the example. The totals are indicated on the printout with asterisks (*) that show the drilldown level for which the sum was calculated. Thus the sum for each product group is represented with one asterisk, the sum for the customer group with two asterisks, and the grand total for all customer groups with three asterisks.

The following table demonstrates how the system drills down in the report and sends the rows to the pages of the printout.

As you can see from this example, the number of rows printed depends on

• The number of levels drilled down for the printout