Tabular Reports › How Report Sorting Works › Sort Reports by Different Keys

Sort Reports by Different Keys

To sort columns by different keys, alter the order of the columns.

To create a report showing the five terminals using the most transactions, make the variable TRAN USE the first variable in the TAB command:

TAB TERMID(0A++) FOR 5 TRAN USE     AND,
                       TERM RESP    AND,
                       TERM I/OTIME
END
RUN

A report like the following is generated:

   TERM     TRAN     TERM     TRAN
   ID       USE     RESP     TMIO
-------- -------- -------- --------
0A12        401    0.226    1.477
0A09        180    0.064    8.602
0A02        115    0.194    10.71
0A19         80    0.202    144.2
0A0E         59    0.793    2.686
-------- -------- -------- --------
SUMMARY     835    0.197    18.05
-------- -------- -------- --------