Using QMF

Specifying text for the subtotal line on a report

You can specify the text you want to display at each subtotal line in your report. If you do not specify the text, asterisks display at each subtotal line.

To specify text for subtotal lines:

1. On the QMF command line, enter:

   SHOW FORM.BREAK1
   

   The FORM.BREAK1 panel displays.

   Figure 98. Enter the subtotal text in the BREAK 1 FOOTING TEXT field.
   

   +--------------------------------------------------------------------------------+
   | FORM.BREAK1                                                                    |
   |                                                                                |
   | New Page for Break?        ===> NO      Repeat Detail Heading?    ===> NO      |
   | Blank Lines Before Heading ===> 0       Blank Lines After Heading ===> 0       |
   | LINE  ALIGN   BREAK 1 HEADING TEXT                                             |
   | ----  ------  ----+----1----+----2----+----3----+----4----+----5----+          |
   | 1     LEFT                                                                     |
   | 2     LEFT                                                                     |
   | 3     LEFT                                                                     |
   |               *** END ***                                                      |
   |                                                                                |
   | New Page for Footing?      ===> NO      Put Break Summary at Line ===> 1       |
   | Blank Lines Before Footing ===> 0       Blank Lines After Footing ===> 1       |
   | LINE  ALIGN   BREAK 1 FOOTING TEXT                                             |
   | ----  ------  ----+----1----+----2----+----3----+----4----+----5----+          |
   | 1     RIGHT   DEPT. &2 TOTALS                                                  |
   | 2     RIGHT                                                                    |
   | 3     RIGHT                                                                    |
   |               *** END ***                                                      |
   +--------------------------------------------------------------------------------+

2. 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.

   The &2 is a form variable that tells QMF to display the current value in column 2 for each subtotal line. Column 2 is the DEPT_NUMBER column, so the current department number displays as part of the text for each subtotal line.

3. Press the Report function key to see the changed report.

   Figure 99. The changed report shows subtotal text after each department.
   

   +--------------------------------------------------------------------------------+
   |   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               |
   |                        ------------  -----------    ------------               |
   |       DEPT. 15 TOTALS    $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               |
   |                        ------------  -----------    ------------               |
   |       DEPT. 20 TOTALS    $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               |
   |                        ------------  -----------    ------------               |
   |       DEPT. 38 TOTALS    $59,778.80    $1,913.30      $61,692.10               |
   |                                                                                |
   |                        ============  ===========    ============               |
   |                         $146,976.93    $4,249.15     $151,226.08               |
   +--------------------------------------------------------------------------------+

For information on specifying text for additional form breaks, see the QMF Reference, SC26-4716-05.