DB2 graphic  QMF Version 8

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 101. 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 102. 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 DB2 QMF Reference.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004