How To Format Reports Containing Calculations › Displaying Only Detail Lines

Displaying Only Detail Lines

In this step, you modify your report definition so that it displays only detail lines (those lines that do not contain any summary computations).

Start on the Report Format - Sort screen. To get there, type sort on the command line of any screen. Type a character next to Detail to restore the display of detail lines. Type a blank next to Summary to suppress the display of rows containing summary computations.

      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
  _  EMP-LAST-NAME                                     3        A          _
  X  DEPT-ID                                 1         1        A          1
  X  SALARY-AMOUNT                           4         _        _          _
  _  PROJECT                                           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 x  and/or  Summary         Group by all X
  Compute:

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

CA OLQ displays only detail lines.

     CA OLQ Release nn.n                          *** Display Report ***
 ->                                                       Page     1 Line     1
104009 DISPLAY RIGHT to see more report columns
125004 Press the ENTER key for DISPLAY/FORMAT ACTIVITY selections
                                 EMPLOYEE REPORT
                                    mm/dd/yy

      DEPT-ID                SALARY-AMOUNT                 EMP-LAST-NAME
      ───────     ───────────────────────────────────     ───────────────
      4000                                   37000.00     ZEDI
                                             18000.00     ANGELO
                                             34000.00     JACKSON
                                             18000.00     MCDOUGALL
                                             39000.00     PENMAN
                                             80000.00     BANK
      5200                                   38000.00     CLOTH
                                             31000.00     KASPAR
                                             45000.00     FINN
                                             33000.00     TIME
                                             80000.00     WILCO
     END OF REPORT

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