WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP WF Client: 7.1.4 on Windows 2K3 w/Tomcat
September 18, 2009, 09:35 AM
Tom Flynn
Forget ON TABLE, use a DUMMY column:
DEFINE FILE GGSALES
DUMMY/A1=' ';
END
TABLE FILE GGSALES
PRINT
PRODUCT AS ''
UNITS AS ''
DOLLARS AS ''
BY DUMMY NOPRINT
BY CATEGORY AS ''
ON DUMMY SUBHEAD
"This is the Heading Line 1"
"This is the Heading Line 2"
"This is the Heading Line 3"
" "
"Category<+0>Product<+0>Units<+0>Amount"
" "
ON TABLE SET HTMLCSS ON
-*ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
GRID=OFF,
RIGHTGAP=0.125000,
$
TYPE=SUBHEAD, HEADALIGN=BODY, STYLE=BOLD,$
TYPE=SUBHEAD, LINE=1, JUSTIFY=CENTER, COLSPAN=5,$
TYPE=SUBHEAD, LINE=2, JUSTIFY=CENTER, COLSPAN=5,$
TYPE=SUBHEAD, LINE=3, JUSTIFY=CENTER, COLSPAN=5,$
TYPE=SUBHEAD, LINE=5, STYLE=BOLD+UNDERLINE,$
TYPE=SUBHEAD, LINE=5, ITEM=1, JUSTIFY=LEFT,$
TYPE=SUBHEAD, LINE=5, ITEM=2, JUSTIFY=LEFT,$
ENDSTYLE
END
-EXIT
TABLE FILE CAR
PRINT RETAIL_COST DEALER_COST
BY COUNTRY PAGE-BREAK
BY CAR
BY MODEL
ON TABLE SUBHEAD
"THIS IS ONLY ON THE FIRST PAGE"
ON TABLE PCHOLD FORMAT PDF
END
Don't forget about ON TABLE, but don't forget either about the Column you define just for Mastering precise treatments at break levels C and F, One of the pleasures, with Focus, is there is not a single, compulsory Path. - Could write a book about that, but, another time ...
Focus Mainframe 7.6.11 Dev Studio 7.6.11 and !!! PC Focus, Focus for OS/2, FFW Six, MSO