March 20, 2008, 09:49 AM
Spencetry this:
TABLE FILE CAR
PRINT COUNTRY
OVER MODEL NOPRINT
ON TABLE PCHOLD FORMAT EXL2K
END
March 20, 2008, 09:52 AM
mgrackinIf the text is truely in a HEADING, add the following setting to your report code:
TYPE=HEADING, HEADALIGN=BODY,$
Here's an example:
TABLE FILE CAR
HEADING
"THE COUNTRY IS <COUNTRY"
PRINT RCOST DCOST
BY COUNTRY NOPRINT
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY,$
ENDSTYLEEND
March 20, 2008, 11:03 AM
Francis MarianiI'd be surprised if EXL2K exists for version 5.2.3.
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
March 20, 2008, 05:12 PM
DougPerhaps you can consider the use of COLSPAN. The following is how I handled a similar situation:
TYPE=HEADING, LINE=1, COLSPAN=16, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=2, COLSPAN=16, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=3, ITEM=1, JUSTIFY=RIGHT, COLSPAN=6,$
TYPE=HEADING, LINE=3, ITEM=2, JUSTIFY=CENTER, COLSPAN=3,$
TYPE=HEADING, LINE=3, ITEM=3, JUSTIFY=LEFT, COLSPAN=7,$
TYPE=HEADING, LINE=4, COLSPAN=16, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=5, JUSTIFY=CENTER, SIZE=9,$
TYPE=HEADING, LINE=5, ITEM=1, JUSTIFY=LEFT, COLSPAN=12,$
TYPE=HEADING, LINE=5, ITEM=2, JUSTIFY=LEFT, COLSPAN=4,$
TYPE=HEADING, LINE=6, JUSTIFY=LEFT, SIZE=9,$
TYPE=HEADING, LINE=6, ITEM=1, COLSPAN=12,$
TYPE=HEADING, LINE=6, ITEM=2, COLSPAN=4,$
-Doug
September 09, 2008, 09:45 AM
ColdWhiteMilkI decided to search before posting, and once I found the right keyword (COLSPAN), I found this thread, which
almost solves my problem.
The COLSPAN setting works perfectly, but I have a 5 column report, and I want the heading line that appears in two columns to appear over columns 2-5. What do I use for the HEADING values so that WebFOCUS will notice the two different ITEMS?
September 09, 2008, 09:52 AM
<JG>stick in spot markers <+0>
September 09, 2008, 10:02 AM
GinnyJakesEXL2K did exist for 5.2.3.
September 09, 2008, 10:13 AM
ColdWhiteMilkThe header line shows up in one cell as:
"1 2 3 4 5 This Should Be 6"
I've got:
TABLE FILE SF86REVIEW
HEADING
"<+0>1<+0>2<+0>3<+0>4<+0>5<+0>This Should Be 6<0>"
PRINT
SF86REVIEW.STATUS AS 'Status'
SF86REVIEW.SCT01 AS '1'
SF86REVIEW.SCT07 AS '7'
SF86REVIEW.SCT08 AS '8'
SF86REVIEW.SCT09 AS '9'
SF86REVIEW.SCT10 AS '10'
ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE,$
TYPE=TITLE, COLOR=NAVY, STYLE=BOLD+UNDERLINE, FONT=ARIAL, SIZE=10,$
TYPE=REPORT, TITLETEXT= 'RESULTS', $
TYPE=TABHEADING,STYLE=BOLD,$
TYPE=HEADING,LINE=1,ITEM=6, STYLE=BOLD,COLSPAN=2, JUSTIFY=CENTER,COLOR=AQUA,$
TYPE=SUBFOOT,STYLE=BOLD,$
TYPE=TABFOOTING,STYLE=BOLD,$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
September 09, 2008, 10:20 AM
<JG>quote:
TYPE=HEADING, HEADALIGN=BODY,$
You forgot didn’t you
September 09, 2008, 10:28 AM
ColdWhiteMilkquote:
TYPE=HEADING, HEADALIGN=BODY,$
Thank you. That fixed it!