I have a report that gets output to EXL2K. I have the following code. I need the 5 subheadings to appear individually in columns A-E in Excel. The subheading is instead appearing as one subheading in column A in Excel. Thanks.
ON TABLE SUBHEAD
"Overall Results<+0><Q1_HEADING><+0><Q2_HEADING><+0><Q3_HEADING><+0><Q4_HEADING>"
TYPE=TABHEADING, COLSPAN=5,$
This message has been edited. Last edited by: Michele Brooks,
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
December 16, 2015, 09:39 AM
Francis Mariani
Use HEADALIGN=BODY:
TABLE FILE CAR
PRINT
*
ON TABLE SUBHEAD
"OVERALL RESULTS<WIDTH<HEIGHT<LENGTH<WEIGHT"
ON TABLE SET STYLE *
TYPE=TABHEADING, HEADALIGN=BODY, $
END
Remove your <+0> tags...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 16, 2015, 03:26 PM
Michele Brooks
Thanks so much. I'll give it a try.
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output
December 17, 2015, 02:56 PM
Michele Brooks
Francis, your suggestion worked perfectly. Thanks again.