Filter
Top Products
Page 2
┌─────────────────────────────────────────────────────┐
│ Placed Records : Record 5 │
│ Record 6 │
│ Record 7 │
│ │
│ Summary data of Sales for page │
│ │
│ First value : 8 (from Record 5) │
│ Last value : 3 (from Record 7) │
│ Total : 114 (from Record 5-7) │
│ Average : 38 (Total/record count) │
│ Maximum : 8 (from Record 5) │
│ Minimum : 4 (from Record 6) │
│ Record count: 3 │
│ │
│ Summary data of SALES for page break │
│ │
│ First value : 2 (from Record 1) │
│ Last value : 3 (from Record 7) │
│ Total : 294 (from Record 1-7) │
│ Average : 42 (Total/record count) │
│ Maximum : 1 (from Record 3) │
│ Minimum : 4 (from Record 6) │
│ Record count: 7 │
│ │
└─────────────────────────────────────────────────────┘
Note: The page break occurs on record 8. Record 8 is printed on the next page.
The summary data for the page break summarizes all sales data for
PRODUCT Color TV.
Page 3
┌─────────────────────────────────────────────────────┐
│ Placed Records : Record 8 │
│ Record 9 │
│ Record 1 │
│ Record 11 │
│ │
│ Summary data of Sales for page │
│ │
│ First value : 1 (from Record 8) │
│ Last value : 3 (from Record 11) │
│ Total : 66 (from Record 8-11) │
│ Average : 165 (Total/record count) │
│ Maximum : 3 (from Record 11) │
│ Minimum : 6 (from Record 1) │
│ Record count: 4 │
│ │
│ Summary data of SALES for page break │
│ │
│ First value : 1 (from Record 8) │
│ Last value : 3 (from Record 11) │
│ Total : 66 (from Record 8-11) │
│ Average : 165 (Total/record count) │
│ Maximum : 3 (from Record 11) │
│ Minimum : 6 (from Record 1) │
│ Record count: 4 │
│ │
└─────────────────────────────────────────────────────┘
Note: The page break occurs on record 12. This page contains the last record
before the page break, so the summary data for the page break is printed
on this page. The previous page break occurred on the previous page, so
the summary data for the page break is equal to the summary data for the
page, and it summarizes all sales data for PRODUCT Radio.
The end of data is handled as a page break. The summary data for the page
break is printed on the last page.
To define summary data in a text element or a box element in a page layout, you
need to specify which field is summarized, and which summary data is printed on
the
Text data
prompt by typing an ampersand(&), the field name, a left parenthesis
'(', the strings for the summary data, a right parenthesis ')', and a period '.' without
inserting any spaces as follows:
Text data . . . . &SALES(ᑍTOTAL).___________________________
Chapter 10. Work with PFD Definitions 175