How To Format Reports Containing Calculations › Displaying Only Summary Computations

Displaying Only Summary Computations

In this step, you modify your report definition so that it displays only those report rows that contain summary computations.

Start on the Report Format - Sort screen. To get there, type sort on the command line of any screen.

Type a blank next to Detail to suppress the display of detail lines.

     CA OLQ Release nn.n                           *** Report Format - Sort ***
 ->                                                       Page     1 of     2
133000 Specify sort or group by request and press the ENTER key

                                           Disp      Sort    Order     Group By
                                           Seq     Priority  (A/D)      Level #
   EMPLOYEE
 X  EMP-LAST-NAME                           3         3        A          _
 X  DEPT-ID                                 1         1        A          1
 X  SALARY-AMOUNT                           4         _        _          _
 X  PROJECT                                 2         2        A          2

   COMPUTE FIELDS:
 X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM
   OUNT) GROUP BY ALL LEVEL 1

 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E
   MPLOYEE.SALARY-AMOUNT) GROUP BY
    EMPLOYEE.DEPT-ID LEVEL 1

           Display lines:  Detail    and/or  Summary X       Group by all X
 Compute:

 1=HELP    3=QUIT    4=MESSAGE    5=DISPLAY    6=MENU    8=FWD    11=HEADER

CA OLQ displays only rows containing summary computations. Page right (PF11) to see the entire report.

     CA OLQ Release nn.n                          *** Display Report ***
 ->                                                       Page     1 Line     1
125004 Press the ENTER key for DISPLAY/FORMAT ACTIVITY selections

                                 EMPLOYEE REPORT
                                    mm/dd/yy

             DEPT-ID                       SALARY-AMOUNT
             ───────            ───────────────────────────────────
             4000                                          37000.00
             4000                                          39000.00
             4000                        AVERAGE SALARY:   37666.66

             5200                                          31000.00
                                         AVERAGE SALARY:   45400.00

                                TOTAL SPENT IN SALARIES:  453000.00

     END OF REPORT



                                      - 1 -
 1=HELP       3=QUIT       4=MESSAGE       6=MENU       10=LEFT       11=RIGHT