Tabular Reports › How Report Sorting Works

How Report Sorting Works

Sorting reports lets you customize the resulting report.

To sort reports, consider the following default sorting process:

1. Tabular reports are sorted from left to right with respect to the variable values, in descending order.
2. The leftmost variable is considered first; if the value is the same for two entries, the variable to the right is considered.
3. This sorting continues until variable values differ.

Example: Commands to Sort a Report

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

This example produces the following report. The terminal 0A0E had the highest response time, so it is listed first. Terminals 0A14 and 0A12 have the same response time, but 0A14 had a higher I/O time, so it precedes 0A12 in the report:

TERM      TERM     TRAN     TRAN
 ID       RESP     TMIO      USE
-------- -------- -------- --------
0A0E      0.793    2.686       59
0A14      0.226    4.747       31
0A12      0.226    1.477      401
0A19      0.202    144.2       80
0A02      0.194    10.71      115
-------- -------- -------- --------
SUMMARY   0.220    19.92      686
-------- -------- -------- --------