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 | Tue May 07 1991 00: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 |