Tabular Report
Use the Tabular Report option to generate formal printed reports with columns of data values (for example, response time, and cost) 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.
micsrm140cd
Use the Tabular Report option to generate formal printed reports with columns of data values (for example, response time, and cost) 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.
Sample 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 | +----------------------------------------------------------------------+
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.
This report 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.