How to Create Report Totals and Subtotals › A Quick Example: Creating a Subtotal › The Report Format - Sort screen › Step 2 - Create report groups

Step 2 - Create report groups

You also specify your group levels on the Report Format - Sort screen. Your Report Format - Sort screen looks like this:

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

                                           Disp      Sort    Order     Group By
                                           Seq     Priority  (A/D)      Level #
   CA OLQ-EXAMPLE
 X  LAST-NAME                               1         _        _          _
 X  COUNTRY                                 6         2        a          2
 X  FINISH-TIME                             5         3        a          _
 X  SEX                                     4         1        a          1









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

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

Group By Level # is used to specify group levels.

                                         BOSTON MARATHON
                                            mm/dd/yy

                                   LAST NAME    SEX    COUNTRY     FINISH TIME
                                  ┌───────────────────────────────────────────┐
                                ┌─┤VANDER WYK   F      BELGIUM     2:54:12    │
Group Level 2                   │ │FRECETTE     F      BELGIUM     3:10:01   │
Group field = COUNTRY ──────────┼─►HELFGOTT     F      BELGIUM     3:24:31    │
                                │ └─────────────────────────────────────────┬─┘
                                │                                           │
                                │  DECRE        F      FRANCE      3:11:09  │
                                │  BENOTTI      F      ITALY       3:12:42  │
                                │  FUCCI        F      ITALY       3:40:37  │
                                │  BJORNSEN     F      SWEDEN      2:59:12  │
Group Level 1                   │                                          │
Group field = SEX     ──────────►                                           │
                                │  KLEIN        F      USA         3:09:24  │
                                └───────────────────────────────────────────┘

                                   VANPRAAG     M      BELGIUM     2:45:60
                                   MARTIN       M      FRANCE      3:10:29
                                   GUERRIERI    M      ITALY       2:19:30
                                   BARBADO      M      ITALY       2:40:12
                                   YAMADA       M      JAPAN       2:30:41
                                   KEEFE        M      USA         2:40:19
                                   SIMON        M      USA         2:52:48
                                   PARSONS      M      USA         3:00:04

Group Levels: This report is grouped at two levels: by SEX (level 1) and by COUNTRY (level 2).