S A M P L E   F O C E X E C S

Report Headings and Footings

The command to create a heading or footing follows the table file command. More than one heading or footing can be created. Use the heading or footing command. Then, enclosed within double quotes, on the next line type the text of the heading or footing. A blank line can be produced by typing " ". The heading or footing can be centered if desired.

Get in the habit of including the effective date of the information in the title. Using the symbol <, followed by the data element "filedate," will automatically print the month of the file you are using. In addition, you should indicate if the file was the preliminary or final. 

>
>
tfs
heading center
"count of employees"
"effective preliminary <filedate"
" "
footing
"includes all employees"
count empno
by csex
across campus
end

NUMBER OF RECORDS  IN TABLE=    807    LINES= 2

PAGE         1

                          COUNT OF EMPLOYEES
                     EFFECTIVE PRELIMINARY APR84

      CCAMPUS
           01    02    03    04    05    06    07    08    09
CSEX
----------------------------------------------------------------
F          48    50    74    93    26    50    12    27    48
M          60    37    72    74    20    44    13    26    33

INCLUDES ALL EMPLOYEES
The heading and footing commands can be used after any table file command, including reports using alternate file views.

Time and Date Stamp

An automatic time and date stamp can be included in the heading, but only from a stored program (see section on XEDIT). Include the following in the heading: 

          "date:   &date"
          "time"   &tod"
This will produce a heading as follows: 
          DATE:     04/27/88
          TIME:     10.09.21
Back to Sample Focexecs