Tabular reports
Tabular reports in QMF for Workstation provide users with the capability to formulate and present raw data from query results in a tabular report. The design interface includes a Design view for designing and structuring report data and a Runtime view for viewing how the report output is displayed.
The following figure shows an example of a tabular report in Design view.

The following figure shows an example of a tabular report in the raw data view.

The following figure shows an example of a tabular report in the default view.

Creating custom tabular reports with QMF for TSO and CICS® is easy; you can start with a template report that has default column headings and a default layout. Then you can tailor the default report with formatting specifications that control different areas of the report.
The following figure shows a report produced in QMF for TSO and CICS that groups salaries in each department by job.
REPORT LINE 1 POS 1
<------------------ JOB ------------------>
<-- CLERK --> <--- MGR ---> <-- SALES --> <-- TOTAL -->
SUM SUM SUM SUM
DEPT SALARY SALARY SALARY SALARY
------ ----------- ----------- ----------- -----------
10 $83,463.45 $83,463.45
15 $24,766.70 $20,659.80 $16,502.83 $61,929.33
20 $27,757.35 $18,357.50 $18,171.25 $64,286.10
38 $24,964.50 $17,506.75 $34,814.30 $77,285.55
42 $22,014.50 $18,352.80 $18,001.75 $58,369.05
51 $27,829.80 $21,150.00 $37,111.00 $86,090.80
66 $10,988.00 $18,555.50 $56,532.70 $86,076.20
84 $13,030.50 $19,818.00 $33,298.50 $66,147.00
=========== =========== =========== ===========
$151,351.35 $217,863.80 $214,432.33 $583,647.48
ABC Mechanical, Inc.
When you make changes to a QMF form, you can see the results immediately on the report without having to repeatedly fetch information from the database.
- FORM.MAIN
- Used to specify the basic format for the report
This form panel is shown in Figure 5.
- FORM.BREAKn
- Allows you to specify text before and after breaks in a report
There are six break panels (FORM.BREAK1 through FORM.BREAK6), allowing you to specify summary text for up to six breaks in the report.
- FORM.CALC
- Allows you to specify up to 999 calculation expressions in a report
- FORM.COLUMNS
- Allows you to specify the format of columns in the report as well as how to format the data in each column when that data appears in a chart
- FORM.CONDITIONS
- Used together with FORM.DETAIL to specify conditional formatting
in the report
Conditional formatting allows you to create expressions that control when the formatting variations that have been specified in FORM.DETAIL are to be used in the report. If the condition evaluates to true, the formatting specifications associated with that condition are applied to the report.
- FORM.DETAIL
- Allows you to create up to 99 formatting variations, each associated with a condition that you specify on the FORM.CONDITIONS panel
- FORM.FINAL
- Controls the content and placement of final text in a report
- FORM.OPTIONS
- Allows you to fix the position of columns in the
report, which divides the report into a fixed area and a scrollable
area, so that you can easily compare multiple columns in a large report
This panel also allows you to summarize data across columns in the report as well as make other detailed formatting adjustments.
FORM.MAIN MODIFIED
COLUMNS: Total Width of Report Columns: 23 + (N X 15)
A B C D E F
NUM COLUMN HEADING USAGE INDENT WIDTH EDIT SEQ
--- ------------------------------ ------- ------ ----- ----- ---
1 DEPT GROUP 2 6 L 1
2 JOB ACROSS 2 5 C 2
3 SALARY SUM 2 11 D2 3
PAGE: HEADING ===> G
FOOTING ===> COMPANY NAME
FINAL: TEXT ===> H
BREAK1: NEW PAGE FOR BREAK? ===> NO
FOOTING ===> DEPT. &2 TOTALS I
BREAK2: NEW PAGE FOR BREAK? ===> NO
FOOTING ===>
OPTIONS: OUTLINE? ===> YES DEFAULT BREAK TEXT? ===> NO J
1=Help 2=Check 3=End 4=Show 5=Chart 6=Query
7=Backward 8=Forward 9= 10=Insert 11=Delete 12=Report
OK, FORM.MAIN is displayed.
COMMAND ===> SCROLL ===> PAGE
You can apply the same formatting specifications to different sets of query results, saving you time and helping you to maintain reporting consistency across your organization.