Specifying text for the subtotal line on a report
If you do not specify the text that you want to display, asterisks display at each subtotal line.
To specify the text you want to display at each subtotal line in your report:
- Enter SHOW FORM.BREAKn,
where n is the number you specified on the FORM.COLUMNS panel
for this break. In Breaking on a value to add subtotals you specified BREAK1 for the DEPT._NUMBER column, so enter the following on the QMF command line:
The FORM.BREAK1 panel displays.
- Type the text you want to display at each subtotal line
in the BREAK 1 FOOTING TEXT field. For this example, type DEPT. &2 TOTALS, as shown in the following figure.
The &2 is a form variable that tells QMF to display, for each subtotal line, the current value of column 2. The columns are numbered in the same order in which they were selected in the query; each column's number appears in the NUM column of the FORM.COLUMNS panel. In this example, column 2 is the DEPT._NUMBER column, so the current department number displays as part of the text for each subtotal line.
- Press the Report function key to see the changed report,
which is shown in the following figure.