[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 ENDThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.9 Windows all output (Excel, HTML, PDF)