3. Reports and Graphics › 3.2 Printed Reports › 3.2.4 Tabular Report

3.2.4 Tabular Report

    +----------------------------------------------------------------------+
    |                   Prime Shift TSO Activity Summary                   |
    |                                                                      |
    |              Development TSO System,  November 29, 1988              |
    |----------------------------------------------------------------------|
    |             |     | Average Resp.| Pct. Short | Pct. Long  |         |
    |     Time    | Max | Time (sec.)  |   Within   |   Within   | Command |
    |    Period   |Users| Total  Short | 0.50  0.80 | 0.80  1.00 |  Count  |
    |-------------+-----+--------------+------------+------------+---------|
    |  8:00- 9:00 | 120 |  1.23   0.35 | 95.2  99.3 | 94.6  98.2 |   8,742 |
    |  9:00-10:00 | 135 |  1.18   0.36 | 95.7  99.1 | 92.9  96.1 |  10,085 |
    | 10:00-11:00 | 182 |  1.37   0.42 | 93.5  98.4 | 89.4  94.5 |  15,287 |
    | 11:00-12:00 | 228 |  2.11   0.85 | 75.1  82.6 | 63.7  75.2 |  18,167 |
    | 12:00-13:00 |  43 |   .85   0.21 | 99.0  99.9 | 97.6  99.6 |   3,850 |
    | 13:00-14:00 | 174 |  1.42   0.38 | 88.7  92.3 | 88.3  92.9 |  14,920 |
    | 14:00-15:00 | 235 |  2.02   0.79 | 73.4  85.9 | 75.8  84.7 |  18,562 |
    | 15:00-16:00 | 229 |  2.14   0.88 | 72.8  84.6 | 59.7  69.3 |  18,024 |
    |-------------+-----+--------------+------------+------------+---------|
    |   Summary   | 235 |  1.73   0.57 | 88.6  92.1 | 77.3  84.9 | 107,637 |
    +----------------------------------------------------------------------+

Figure 3-17.  Sample Tabular Report


Use the Tabular Report option to generate formal printed
reports with columns of data values (for example, response
time, cost, etc.) over rows of data observations or time
periods (for example, hours of the day). You specify report
sequence, data elements to report, page break and subtotal
controls, and report subheadings.  You can request both
subtotals and grand totals, with subtotal options including
sum (accumulate), maximum/minimum value, percent of total,
and percent/amount of change from the first observation.  A
subtotal derivation extended option is available to define
your own derived subtotal values (for example, average
response time).

Optional parameters allow you to generate multiple report
lines for each input file observation and to control the
specific column in which each item is printed.  Column
headings are specified for each data value or overridden with
free-form, multiple line column headings.  You can even
include footnotes on the report.

Figure 3-17 is a sample tabular report providing a prime
shift TSO activity summary.

To create a tabular report, select the Tabular Report option
from the Structured Inquiry Printed Reports Menu.