Hi All,

In Excel Reports, Can i get the header format shown below..

ABC DEF
ABC BCD CDE EFG

I need to have the header ABC DEF and below that there should be 4 different columns.
ABC DEF should come in the middle.

This message has been edited. Last edited by: Kerry,

Hi Subhash,

For Excel/HTML the HEADALIGN=BODY (must be on a line by itself) may be what you are needing:

TABLE FILE CAR
PRINT
BODYTYPE AS 'CDE'
SALES AS 'EFG'
BY COUNTRY AS 'ABC'
BY CAR AS 'BCD'
HEADING
"ABC DEF"
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=9,$
TYPE=TITLE, STYLE=BOLD+UNDERLINE, SIZE=10,$
TYPE=HEADING, HEADALIGN=BODY,$
TYPE=HEADING, LINE=1,STYLE=BOLD,JUSTIFY=CENTER,COLSPAN=4,$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

subhash,
Let us know if that does not work for you. If so, close the post and enjoy your WebFOCUSing...

[Close]It Works....Thanks and sorry for delay.