| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
I have checked the manuals for this answer (Ver 5.2).
I am trying to change report width to something greater than 132.
Currently, whenever I create a report with more than 132 characters,
the remainding columns are wrapped to pages 1.1, 2.1, 3.1 ect.
I have a filelayout requirement that requires parameters in positions
133-136. The parameter will determine whether the field contains data
or headings. I am using the sales_cd variable to hold the dummy data.
I have not had any luck with set width or set panel commands.
Any other suggestions?
SET ALL=OFF
DEFINE FILE BILLING
TRANSFER = (STD_COST*SHIP_QTY);
WAYBILL_NO/A41 = ' ';
SALES_CD/A2 = '6';
CHRG_NO_NEW/A4 = EDIT (CHRG_NO, '999$$$$$$$$');
END
TABLE FILE BILLING
PRINT
CHRG_NO
DEC_NO
SDC_ORDER_NO AS 'SSB ORDER NO'
PART_ID
SHIP_QTY AS 'QTY'
STD_COST
TRANSFER
BADGE_NO
WAYBILL_NO
CHRG_NO_NEW AS 'COC'
SALES_CD AS '4'
BY CHRG_NO NOPRINT
IF FMO EQ &FMO
IF ACC_CUS_TYPE EQ DC OR MA
IF RECORDLIMIT EQ 25
END
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 414.1 | GERBIL::IMFRA | Mon May 06 1991 23:46 | 20 | ||
PANEL is definitely the parameter which needs to be set. Since you
mentioned having set this to a gt 132 value, I can only presume your
SET PANEL statement is appearing before your OFFLINE statement,
assuming you are directing your reports to a file via OFFLINE.
One (of many) quirky things about FOCUS is that when the OFFLINE
statement is issued, it automatically sets the report formatting
paramaters (e.g. PANEL) to the FOCUS default (132 for PANEL in OFFLINE
mode).
To override the defaults, place any SET commands after the OFFLINE
statement, or, alternately, set panel as you normally would then use
ON TABLE HOLD AS ________ FORMAT DOC to generate your reports
(rather than OFFLINE). This last way has an added benefit: when
a report is generated in this manner, it retains its page break control
when extracted from Vaxmail and subsequently printed (unlike report
files generated using OFFLINE).
Hope this helps!
jb
| |||||