To include subtotals in the report, specify a BREAK usage code that tells QMF where to make a break in the report and calculate a subtotal.
The BREAKn usage code divides the report whenever the value of the associated column changes. Control breaks are the points at which a report breaks. Control columns are the columns that govern control breaks. You can have up to six breaks in a report. To indicate a break, you type the word BREAK and follow it with a number from 1 to 6.
In this example, you add a break to one column to divide the report every time the department number changes.
Because you want to show subtotals by department (calculate a subtotal whenever the department number changes), specify the break usage code in the DEPT_NUMBER column. Therefore, the DEPT_NUMBER column is the control column.
To add subtotals:
FORM.COLUMNS MODIFIED Total Width of Report Columns: 64 NUM COLUMN HEADING USAGE INDENT WIDTH EDIT SEQ --- ---------------------------------------- ------- ------ ----- ----- --- 1 EMPLOYEE_NAME 4 9 C 3 2 DEPT._NUMBER BREAK1 2 6 L 1 3 JOB OMIT 4 5 C 2 4 SALARY SUM 2 12 D2 4 5 COMMISSIONS SUM 2 11 D2 5 6 TOTAL_EARNINGS SUM 4 12 D2 6 *** END ***
DEPT. EMPLOYEE TOTAL NUMBER NAME SALARY COMMISSIONS EARNINGS ------ --------- ------------ ----------- ------------ 15 KERMISCH $12,258.50 $110.10 $12,368.60 NGAN $12,508.20 $206.60 $12,714.80 ROTHMAN $16,502.83 $1,152.00 $17,654.83 ------------ ----------- ------------ * $41,269.53 $1,468.70 $42,738.23 20 JAMES $13,504.60 $128.20 $13,632.80 PERNAL $18,171.25 $612.45 $18,783.70 SNEIDER $14,252.75 $126.50 $14,379.25 ------------ ----------- ------------ * $45,928.60 $867.15 $46,795.75 38 ABRAHAMS $12,009.75 $236.50 $12,246.25 NAUGHTON $12,954.75 $180.00 $13,134.75 O'BRIEN $18,006.00 $846.55 $18,852.55 QUIGLEY $16,808.30 $650.25 $17,458.55 ------------ ----------- ------------ * $59,778.80 $1,913.30 $61,692.10 ============ =========== ============ $146,976.93 $4,249.15 $151,226.08
For more information on specifying control breaks, see the QMF Reference .
[ Previous Page | Next Page | Contents | Index ]