DB2 graphic  QMF Version 8

Using the QMF default report format

When you display a report by using the default report format, the report looks like the one in Figure 78.

Figure 78. QMF uses a default report format like this one.
NAME         DEPT  JOB      SALARY       COMM
 ---------  ------  -----  ----------  ----------
 KERMISCH       15  CLERK    12258.50   110.10
 NGAN           15  CLERK    12508.20   206.60
 ROTHMAN        15  SALES    16502.83  1152.00
 JAMES          20  CLERK    13504.60   128.20
 PERNAL         20  SALES    18171.25   612.45
 SNEIDER        20  CLERK    14252.75   126.50
 ABRAHAMS       38  CLERK    12009.75   236.50
 NAUGHTON       38  CLERK    12954.75   180.00
 O'BRIEN        38  SALES    18006.00   846.55
 QUIGLEY        38  SALES    16808.30   650.25 

By tailoring the report format, you can use the same data to produce the report in Figure 79.

Figure 79. A customized report can show the same data in different ways.
                            DIVISION EARNINGS REPORT
 
 
   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
 
 
                              COMPANY NAME


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