FORM.PAGE

Use FORM.PAGE to make detailed choices about the content and placement of the page headings and footings in a report. For online and printed reports, QMF places headings at the top of an online report and footings at the bottom. Headings and footings appear at the top and bottom of each page of a printed report.

Area G on the FORM.MAIN panel (see G PAGE on page***) specifies page headings and footings for a report. Whatever you specify in area G of FORM.MAIN is shown on FORM.PAGE. Similarly, the first line of page heading and footing that you specify on FORM.PAGE is shown on FORM.MAIN.

FORM.PAGE A Blank Lines Before Heading ===> 0 B Blank Lines After Heading ===> 2 C LINE D ALIGN E PAGE HEADING TEXT ---- ------ ----+----1----+----2----+----3----+----4----+----5----+ 1 CENTER 2 CENTER 3 CENTER 4 CENTER F Blank Lines Before Footing ===> 2 G Blank Lines After Footing ===> 0 H LINE I ALIGN J PAGE FOOTING TEXT ---- ------ ----+----1----+----2----+----3----+----4----+----5----+ 1 CENTER 2 CENTER 3 CENTER 4 CENTER *** END *** 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.PAGE is displayed. COMMAND ===> SCROLL ===> PAGE

A Blank lines before heading

Reports: Specify the number of blank lines between the top of a page and the first line of the page heading. The value can be any number from 1 through 999.

Charts: An entry in this area determines vertical placement of the heading on the chart. However, too many blank lines can change the labels on the Y-axis.

B Blank lines after heading

Reports: Specify the number of blank lines between the last line of page heading and the body of the report. The value can be any number from 1 through 999. The default is 2.

C LINE

Reports: Identify the lines of page heading text and specify their position relative to themselves and to the line at which the page heading starts (as indicated in the Blank Lines Before Heading entry area).

The numbers you choose need not start with 1 or be consecutive. You can choose spacing between the lines of the page heading and between the top of the page and the first line of page heading text. A blank ignores any associated text.

For example, these values on FORM.PAGE:

    LINE  ALIGN   PAGE HEADING TEXT
    ----  ------  ----+----1----+----2----
    4     LEFT    MONTHLY INVENTORY
    4     RIGHT   PAGE &PAGE
    2     CENTER  ABC COMPANY

Display as:

                ABC COMPANY
 
      MONTHLY INVENTORY       PAGE 1

Charts: Use LINE to position the lines of heading text vertically relative to themselves and to the line at which the chart (page) heading starts.

D ALIGN

Reports: Specify where each line of the page heading text is placed horizontally in the report. You can place the lines anywhere in the width of the report. For an online report, the width is the width of the displayed report; for a printed report, the width is the page width.

Left: Left-justifies the line of page heading text.
Right: Right-justifies the line of page heading text.
Center: Centers the line of page heading text.
n: Begins the line of page heading text in the nth position of the line. n can be any number from 1 through 999999.

Append

Attaches the line at the end of the previous line of page heading text. If append is used on the first line of page heading text, the line of text is left-justified.

The appended line of text must have the same LINE value as the line of text it is being appended to. If the report is not wide enough to accommodate the appended line of text, some of the text might be truncated.

For example, the following entries on FORM.PAGE:

    LINE  ALIGN    PAGE HEADING TEXT
    ----  ------  ----+----1----+----2----
    1     CENTER   ABC COMPANY MANAGERS --
    1     APPEND    &DATE, &TIME
    3     CENTER
    4     CENTER
    5     CENTER

Align the columns like this:

                  ABC COMPANY MANAGERS -- 98/08/04, 14:20
 
 
         ID  NAME         DEPT  JOB     YEARS      SALARY        COMM
     ------  ---------  ------  -----  ------  ----------  ----------
         10  SANDERS        20  MGR         7    18357.50           -
         30  MARENGHI       38  MGR         5    17506.75           -

Charts: ALIGN does not affect a chart heading, except when LINE is used to place more than one line of text on the same line of the heading.

E PAGE HEADING TEXT

Reports: Enter the text you want to appear either at the top of each page of a printed report or before the first line of a report displayed at a terminal. You can add up to 999 lines of page heading text using the INSERT command. Each line of text can be up to 55 characters long. You can add text to the line by using APPEND as the ALIGN value, or by specifying a specific horizontal position.

If your installation supports DBCS data, see Names with double-byte characters.

To make the page heading text appear in a report in uppercase and lowercase, specify in your PROFILE a CASE value of either STRING or MIXED:

STRING: Displays the page heading text as entered, but converts any other input to uppercase.
MIXED: Displays all input exactly as entered.

Page headings can contain the following variable values:

&n: n is a number that stands for the first value in column n on the current page of this report. Column n is the nth column selected from the database, or the nth column listed on FORM.MAIN and FORM.COLUMNS.
&ROW: The number of the first data row on the current page is printed or displayed in your report.

&DATE: The current date
&TIME: The current time
&PAGE: The current page number

When &DATE, &TIME, or &PAGE are entered in page heading text, the system date, time, or page number do not appear at the bottom of printed reports. This applies only to these three variables entered on FORM.PAGE.

For descriptions of &DATE, &TIME, and &PAGE, see page*** under BREAK1 HEADING TEXT.

Charts: The preceding description regarding PAGE HEADING TEXT applies to charts, except for part of the description of ALIGN. The only time that the value specified for ALIGN affects a chart heading is when LINE is used to place one or more lines of text entered on FORM.PAGE on the same line in the formatted report. If you're not using the LINE function, the chart heading is automatically centered.

F Blank lines before footing

Reports: Specify the number of blank lines between the body of the report and the first line of page footing. The value for this entry can be any number from 1 through 999. The default is 2.

G Blank lines after footing

Reports: Specify the number of blank lines between the last line of page footing and the bottom of the page. The value for this entry can be any number from 1 through 999.

If a report contains break summary data and one or more wrapped columns, you might need to increase the value in this entry area to see all the lines of summary data. For more information, see the CW code under Edit Codes for Character Data.

H LINE

Reports: Identify the lines of page footing text and specify their position relative to themselves and to the line at which the page footing starts (as indicated in the Blank Lines Before Footing entry area). You can specify any number from 1 through 999 or a blank.

For example, these values on FORM.PAGE:

LINE  ALIGN   PAGE FOOTING TEXT
----  ------  ----+----1----+----2----
3     LEFT    MONTHLY INVENTORY
3     RIGHT   PAGE &PAGE
2     LEFT    ABC COMPANY

Display as:

ABC COMPANY
MONTHLY INVENTORY       PAGE 1

Notice that a blank line appears before the first line of text.

I ALIGN

Reports: Specify where each line of the page footing text is to be placed horizontally in the report. You can place the lines of text anywhere between the left and right margin. For an online report, the width is the width of the displayed report; for a printed report, the width is the page width.

Left: Left-justifies the line of page footing text.
Right: Right-justifies the line of page footing text.
Center: Centers the line of page footing text.
n: Begins the line of page footing text in the nth position of the line. n can be any number from 1 through 999999.

Append: Positions the line at the end of the previous line of page footing text. If Append is used on the first line of page footing text (the line of text with the lowest LINE value), the line of text is left-justified.
The appended line of text must have the same LINE value as the line of text it is being appended to. If the report is not wide enough to accommodate the appended line of text, some of the text might be truncated.

For example, the following entries on FORM.PAGE:

LINE  ALIGN   PAGE FOOTING TEXT
----  ------  ----+----1----+----2----
1     CENTER  ABC COMPANY MANAGERS --
1     APPEND  &DATE, &TIME

align columns like this:

    ID  NAME         DEPT  JOB     YEARS      SALARY        COMM
------  ---------  ------  -----  ------  ----------  ----------
                              .
                              .
                              .
 
    10  SANDERS        20  MGR         7    18357.50           -
    30  MARENGHI       38  MGR         5    17506.75           -
 
 
                  ABC COMPANY MANAGERS -- 98/08/04, 16:20

J PAGE FOOTING TEXT

Reports: Enter the text you want to appear either at the bottom of each page of a printed report or before the last line of a report displayed at a terminal. You can add up to 999 lines of page footing text using the INSERT command. Each line of text can be up to 55 characters long. You can add text to the line by using APPEND as the ALIGN value, or by specifying a specific horizontal position.

If your installation supports DBCS data, see Names with double-byte characters.

To make the page footing text appear in a report in uppercase and lowercase, specify in your profile a CASE value of either STRING or MIXED:

STRING: Displays page footing text as entered, but converts any other input to uppercase.
MIXED: Displays all input exactly as entered.

Page footings can contain the following variable values:

Global variables: Use SET GLOBAL to set variables for use in page footing text. See SET GLOBAL for details about this command.
&n: n is a number that represents the last row in column n processed for the current page of this report. Column n is the nth column selected from the database, or the nth column listed on FORM.MAIN and FORM.COLUMNS.

&ROW: The number of the last data row on the current page is printed or displayed in your report.
&DATE: The current date
&TIME: The current time
&PAGE: The current page number

When &DATE, &TIME, or &PAGE are entered in page footing text, they appear (instead of the system date, time, or page number) at the bottom of the printed report. This applies only to these three variables entered on FORM.PAGE.

For descriptions of &DATE, &TIME, and &PAGE, see page*** under BREAK1 HEADING TEXT.

Contents

Index