The TOTAL modifier (described earlier in this topic) may be used in combination with the BREAK-ON modifier to total the data for a specified attribute in each section of a report. When the TOTAL modifier and the BREAK-ON modifier are used together, the following occurs:
A subtotal appears in the report for the attribute specified with the TOTAL modifier each time the value of the attribute specified with the BREAK-ON modifier changes.
A total of all of the subtotals appears at the end of the report.
This query shows subtotals for the class dues paid by two classes using the BREAK-ON and TOTAL modifiers together:
>SORT STUDENTS BY TEACHER BY NAME NAME BREAK-ON TEACHER TOTAL |
|||
|
|
|
|
PAGE 1 |
|
11:05:55 DD MMM YYYY |
|
|
|
|
|
STUDENTS... |
Name................ |
Teacher......... |
Dues |
|
|
|
|
4504 |
HARMON, GEORGE |
JONES |
$5.00 |
4505 |
PORTNOY, SYLVIA |
JONES |
$2.00 |
4506 |
RATNER, HEIDI |
JONES |
$9.00 |
4503 |
WATKINS, JOHN |
JONES |
$4.00 |
4507 |
WELCONE, JIM |
JONES |
$7.00 |
|
|
|
|
|
*** |
|
$27.00 |
|
|
|
|
4513 |
BENNETT, NANCY |
KUBOVY |
$3.00 |
4515 |
BERMAN, ANGELA |
KUBOVY |
$5.00 |
4514 |
CURRAN, DIANE |
KUBOVY |
$3.00 |
4516 |
JOHNSON, MEG |
KUBOVY |
$7.00 |
4517 |
KESTER, MICHAEL |
KUBOVY |
$9.00 |
4518 |
TERNY, KEITH |
KUBOVY |
$6.00 |
|
|
|
|
|
*** |
|
$33.00 |
See Also