Focal Point
[CLOSED] HEADER and SUBFOOTER manipulation in excel

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

August 24, 2010, 07:20 PM
dduplechian
[CLOSED] HEADER and SUBFOOTER manipulation in excel
I am trying to insert a header that has a title, and an explanation, and a subfooter that has a signature and date signed. It puts this info into the first cell, how do I get it to spread the header and footer over a large cell, or merge the top cell into one cell?

Here is the code:


TABLE FILE GURUCLS
SUM
dummy AS ''
GURUCLS_CLASS_CODE AS ''
BY dummy AS ''
BY GURUCLS_USERID AS ''
ACROSS CNTR NOPRINT
HEADING
" Place an X in Column A to delete a user entirely. Security Audit Report For Finance. Place an X in the column before each access you want to remove."
ON TABLE SUBFOOT
" I certify this report was verified as of _____/_____/_____ Signature: ____________"
WHERE GURUCLS_CLASS_CODE LIKE 'SFA_FI_%';
ON TABLE SET LINES 999999
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL97
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
COLOR='RED',
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
GRID=OFF,
SIZE=12,
HEADALIGN=BODY,
$
TYPE=HEADING,
GRID=OFF,
LINE=1,
OBJECT=TEXT,
ITEM=4,
COLOR='RED',
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
HEADALIGN=BODY,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

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


WebFOCUS 7.6.9
Windows
all output (Excel, HTML, PDF)
August 24, 2010, 07:31 PM
Waz
COLSPAN, check it out in the documentation.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!