I have a report requirement to display heading in different cells in EXCEL. Searched forum, IBI Tech forums for sample programs.. But couldn't find any prg.
Below sample example puts the entire heading in single line.

TABLE FILE CAR
HEADING
"DISPLAY 1ST CELL <+0> 2ND CELL"
" "
BY COUNTRY 
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, COLSPAN=1,$
TYPE=HEADING, LINE=1, ITEM=2, OBJECT=TEXT, COLSPAN=1,$
ENDSTYLE
END

Any help suggestion would be appreciated.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

Try this:

  
DEFINE FILE CAR
SP/A1=' ';
END
TABLE FILE CAR

BY COUNTRY AS 'DISPLAY 1ST CELL,COUNTRY'
BY SP AS '2ND CELL, '
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
ENDSTYLE
END

Just use HEADALIGN within the stylesheet -

TABLE FILE CAR
HEADING
"DISPLAY 1ST CELL <+0> 2ND CELL"
" "
BY COUNTRY 
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY, $
ENDSTYLE
END

T

Add this to your style section:

TYPE = HEADING, HEADALIGN=BODY,$

Thank you guys.. This resolved my issue.