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

Cheri

is it a column or report heading?

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

try this:

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

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

I'd be surprised if EXL2K exists for version 5.2.3.

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

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?

stick in spot markers <+0>

EXL2K did exist for 5.2.3.

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

quote:

TYPE=HEADING, HEADALIGN=BODY,$

You forgot didn’t you

quote:

TYPE=HEADING, HEADALIGN=BODY,$

Thank you. That fixed it!