SUBHEAD Backcolor in Excel

Hi,

I am trying to create a report in Excel with the subheadings and I need to have the background color as black for these subheadings with the text color in white. But I am only getting the background color for the first column in my o/p excel report. I tried several options but couldn't get it.

This is how I am giving

$
TYPE=SUBHEAD,
LINE=1,
OBJECT=FIELD,
BACKCOLOR=black,
$
TYPE=SUBHEAD,
LINE=1,
OBJECT=FIELD,
COLOR=WHITE,
STYLE=BOLD,
$

I even tried defining it to a CLASS but I am still getting the same message.

Can some one help??

Thanks,
Dayakar

Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10

Posts: 43 | Registered: January 18, 2007

Leah

Virtuoso

posted

Hide Post

TABLE FILE CAR
PRINT CAR MODEL BODYTYPE
BY COUNTRY
ON COUNTRY SUBHEAD
"THIS IS A TEST FOR "
"THIS IS JUNK"
ON TABLE SET ONLINE-FMT EXL2K
ON TABLE SET STYLE *
$
TYPE=SUBHEAD,
LINE=1,
BACKCOLOR=BLACK,
$
TYPE=SUBHEAD,
LINE=1,
COLOR=WHITE,
STYLE=BOLD,
$
END
I think it's the object=field killing you.

Leah

Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004

Ignored post by Leah posted

Show Post

dreddy_23

Silver Member

posted

Hide Post

Thanks for your reply LEAH.

But I am not using the EXL2K directly. I have inclined headings in the report and to get those I need to use HTMLFORMTYPE=XLS.

I copied the code that I am using below. Please see if you can resolve it.

TABLE FILE CAR
PRINT CAR MODEL BODYTYPE
BY COUNTRY
ON COUNTRY SUBHEAD
"THIS IS A TEST FOR "
"THIS IS JUNK"
ON TABLE HOLD AS REP001 FORMAT HTMTABLE
ON TABLE SET STYLE *
$
TYPE=SUBHEAD,
LINE=1,
BACKCOLOR=BLACK,
$
END
-RUN
SET HTMLFORMTYPE=XLS
-HTMLFORM BEGIN

!IBI.FIL.REP001;

-HTMLFORM END
-EXIT

Apriciate it.
Dayakar.

Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10

Posts: 43 | Registered: January 18, 2007

Ignored post by dreddy_23 posted

Show Post

Tom Flynn

Expert

posted

Hide Post

dreddy,

You are close, try:

TYPE=SUBHEAD,
COLOR=BLACK,
BACKCOLOR=WHITE,$

This message has been edited. Last edited by: Tom Flynn,

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

Tony A

Expert

posted

Hide Post

Dayakar,

To obtain the subhead background across all four columns in your example, you need to span it and then use headalign -

TABLE FILE CAR
PRINT CAR MODEL BODYTYPE
BY COUNTRY
ON COUNTRY SUBHEAD
"THIS IS A TEST FOR "
"THIS IS JUNK"
ON TABLE HOLD AS REP001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=SUBHEAD, BACKCOLOR=BLACK, COLOR=WHITE,
COLSPAN=4, HEADALIGN=BODY, $
END
-RUN
SET HTMLFORMTYPE=XLS
-HTMLFORM BEGIN
!IBI.FIL.REP001;
-HTMLFORM END

Enjoy

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

dreddy_23

Silver Member

posted

Hide Post

Tony, Thank you very much, It worked fine. I tried COLSPAN before but I guess HEADALIGN=BODY is what made the difference I guess.

Tom, I tried with your option but it didn't work. Thanks for your reply.

Dayakar.

Prod: WebFOCUS 8.1.05 on Win 10
Test: WebFOCUS 8.1.05 on Win 10

Posts: 43 | Registered: January 18, 2007

Ignored post by dreddy_23 posted

Show Post

Tony A

Expert

posted

Hide Post

You're most welcome