Focal Point
Heading in to seperate cells in excel

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5031079672

March 20, 2008, 09:29 AM
CHERI
Heading in to seperate cells in excel
is it possible to have a heading in two excel cells in WebFocus release 5.23
for example, I want the heading of -
Our Claim Number: 123456

I want the text of 'Our Claim Number' to be in cell 1 and the field value of 123456 to be in cell 2.

Remember, we are using release 5.23
March 20, 2008, 09:45 AM
FrankDutch
Cheri

is it a column or report heading?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

March 20, 2008, 09:48 AM
Prarie
If I understand what you are asking you could

DEFINE FILE WHATEVER
CLAIM/A17 = 'Our Claim Number:';
END
TABLE FILE WHATEVER
PRINT CLAIM AS ' '
VALUE AS ' '
END


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
try this:

TABLE FILE CAR
PRINT COUNTRY
OVER MODEL NOPRINT
ON TABLE PCHOLD FORMAT EXL2K
END


WF 8 version 8.2.04. Windows.
In focus since 1990.
If 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,$
ENDSTYLE

END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
I'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
Perhaps 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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
I 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?


Production - 7.6.4
Sandbox - 7.6.4
stick in spot markers <+0>
EXL2K did exist for 5.2.3.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
The 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



Production - 7.6.4
Sandbox - 7.6.4
quote:
TYPE=HEADING, HEADALIGN=BODY,$


You forgot didn’t you
quote:
TYPE=HEADING, HEADALIGN=BODY,$


Thank you. That fixed it!


Production - 7.6.4
Sandbox - 7.6.4