Using forms panels, you can specify fixed columns on a report.
In an online report, the fixed columns remain in place on the left of the screen when you press the Left or Right function keys. A vertical line | separates the fixed area from the scrollable portion of the report.
On a printed report, QMF repeats the fixed columns on the left side of each page.
For this example, use the query in Figure 102.
PROMPTED QUERY MODIFIED LINE 1 Tables: Q.STAFF(A) Q.ORG(B) Join Tables: A.DEPT And B.DEPTNUMB Columns: ID NAME JOB YEARS SALARY COMM DEPTNUMB DEPTNAME MANAGER DIVISION LOCATION Sort: Ascending by ID
The query creates this report:
ID NAME JOB YEARS SALARY COMM DEPTNUMB DEPTNAME ------ --------- ----- ------ ---------- ---------- -------- --------- 10 SANDERS MGR 7 18357.50 - 20 MID ATLAN 20 PERNAL SALES 8 18171.25 612.45 20 MID ATLAN 30 MARENGHI MGR 5 17506.75 - 38 SOUTH ATL 40 O'BRIEN SALES 6 18006.00 846.55 38 SOUTH ATL 50 HANES MGR 10 20659.80 - 15 NEW ENGLA 60 QUIGLEY SALES - 16808.30 650.25 38 SOUTH ATL 70 ROTHMAN SALES 7 16502.83 1152.00 15 NEW ENGLA 80 JAMES CLERK - 13504.60 128.20 20 MID ATLAN 90 KOONITZ SALES 6 18001.75 1386.70 42 GREAT LAK 100 PLOTZ MGR 7 18352.80 - 42 GREAT LAK 110 NGAN CLERK 5 12508.20 206.60 15 NEW ENGLA 120 NAUGHTON CLERK - 12954.75 180.00 38 SOUTH ATL 130 YAMAGUCHI CLERK 6 10505.90 75.60 42 GREAT LAK 140 FRAYE MGR 6 21150.00 - 51 PLAINS
When you press the Right function key to see the rest of the information, you can no longer see the ID and NAME fields. You cannot tell which information belongs to which employee.
To specify fixed columns on a report:
SHOW FORM.OPTIONSThe FORM.OPTIONS panel displays.
FORM.OPTIONS MODIFIED What do you want for Detail spacing? ===> 1 Line wrapping width? ===> NONE Report text line width? ===> DEFAULT Number of fixed columns in report? ===> 2 Do you want Outlining for break columns? ===> YES Default break text (*)? ===> YES Function name in column heading when grouping? ===> YES Column wrapped lines kept on a page? ===> YES Across summary column? ===> YES Automatic reordering of report columns? ===> NO Page renumbering at the highest break level? ===> NO Do you want separators for Column heading? ===> YES Break summary? ===> YES Across heading? ===> YES Final summary? ===> YES
ID NAME |EPTNUMB DEPTNAME MANAGER DIVISION LOCATION ------ ---------|------- -------------- ------- ---------- ------------- 10 SANDERS | 20 MID ATLANTIC 10 EASTERN WASHINGTON 20 PERNAL | 20 MID ATLANTIC 10 EASTERN WASHINGTON 30 MARENGHI | 38 SOUTH ATLANTIC 30 EASTERN ATLANTA 40 O'BRIEN | 38 SOUTH ATLANTIC 30 EASTERN ATLANTA 50 HANES | 15 NEW ENGLAND 50 EASTERN BOSTON 60 QUIGLEY | 38 SOUTH ATLANTIC 30 EASTERN ATLANTA 70 ROTHMAN | 15 NEW ENGLAND 50 EASTERN BOSTON 80 JAMES | 20 MID ATLANTIC 10 EASTERN WASHINGTON 90 KOONITZ | 42 GREAT LAKES 100 MIDWEST CHICAGO 100 PLOTZ | 42 GREAT LAKES 100 MIDWEST CHICAGO 110 NGAN | 15 NEW ENGLAND 50 EASTERN BOSTON 120 NAUGHTON | 38 SOUTH ATLANTIC 30 EASTERN ATLANTA 130 YAMAGUCHI| 42 GREAT LAKES 100 MIDWEST CHICAGO 140 FRAYE | 51 PLAINS 140 MIDWEST DALLAS