Changing the columns on your report

The first step in producing the report that is shown in Figure 76 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:

  1. Retrieve the data to display on the report by using either a prompted query or an SQL query.

    Figure 77 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
    Figure 77. This query produces the data for the report.
    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
     1 
    QMF retrieves the data from the Q.STAFF table.
     2 
    QMF displays these columns on the report.
     3 
    The employees are nonmanagers from departments 15, 20, and 38.
     4 
    QMF orders the rows by department number, and then by name.
  2. Run the query to display the report.
  3. On the QMF command line, enter SHOW FORM.MAIN.

    The FORM.MAIN panel displays with the default report format for this report:

    Figure 78. You can change column appearance on the QMF FORM.MAIN panel.
    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.

  4. Enter SHOW FORM.COLUMNS.

The FORM.COLUMNS panel displays with the default column information for this report.

Figure 79. The FORM.COLUMNS panel
 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
[ Previous Page | Next Page | Contents | Index ]