The first step in producing the report shown in Figure 79 is to change the appearance of the columns. To change columns, display the FORMS panels for the report.
To display the FORMS panels for a report:
Figure 80 shows the prompted query for the first few examples in this chapter. You can save this query and use it wherever you need it for the examples in this chapter. For example, on the QMF command line, enter:
SAVE QUERY AS NEWQUERY
PROMPTED QUERY MODIFIED LINE 1 Tables: Q.STAFF 1 Columns: 2 NAME DEPT JOB SALARY COMM Row Conditions: 3 If DEPT Is Equal To 15, 20 or 38 And JOB Is Not Equal To 'MGR' Sort: 4 Ascending by DEPT Ascending by NAME
The FORM.MAIN panel displays with the default report format for this report:
FORM.MAIN COLUMNS: Total Width of Report Columns: 50 NUM COLUMN HEADING USAGE INDENT WIDTH EDIT SEQ --- ---------------------------------------- ------- ------ ----- ----- --- 1 NAME 2 9 C 1 2 DEPT 2 6 L 2 3 JOB 2 5 C 3 4 SALARY 2 10 L2 4 5 COMM 2 10 L2 5 PAGE: HEADING ===> FOOTING ===> FINAL: TEXT ===> BREAK1: NEW PAGE FOR BREAK? ===> NO FOOTING ===> BREAK2: NEW PAGE FOR BREAK? ===> NO FOOTING ===> OPTIONS: OUTLINE? ===> YES DEFAULT BREAK TEXT? ===> YES 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 shown. COMMAND ===> SCROLL ===> PAGE
You can make changes to the columns on the FORM.MAIN panel. However, in this example, you will see how to use the FORM.COLUMNS panel to make all the changes to the columns on your report.
The FORM.COLUMNS panel displays with the default column information for this report.
FORM.COLUMNS MODIFIED Total Width of Report Columns: 62 NUM COLUMN HEADING USAGE INDENT WIDTH EDIT SEQ --- ---------------------------------------- ------- ------ ----- ----- --- 1 NAME 2 9 C 1 2 DEPT 2 6 L 2 3 JOB 2 5 C 3 4 SALARY 2 10 L2 4 5 COMM 2 10 L2 5 6 TOTAL_EARNINGS 2 10 C 5 *** END *** 1=Help 2=Check 3=End 4=Show 5=Chart 6=Query 7=Backward 8=Forward 9=Specify 10=Insert 11=Delete 12=Report OK, CANCEL command executed successfully. COMMAND ===> SCROLL ===> PAGE