style sheet question; conditional color w/htmlcss=on

having no luck getting cell color to be conditional , either via macro or direct code, when htmlcss = on.
macro will successfully bold the cell, but not change the color. The cell has a drilldown on it. IF i take the dd off, it goes red ok.
But i need both.
I'm trying to use htmlcss=on so i can easily make that grid very mild.
TYPE=DATA, BORDER=1,BORDER-COLOR=SILVER,
FONT='MS Sans Serif',SIZE=8,$
TYPE=DATA, COLUMN=MYVAR, COLOR=RED,
WHEN=MYVAR GT 500, $
TYPE=DATA, FOCEXEC=&DD1(PARM1=1 \
PARM2=THISDATE ),COLUMN=MYVAR,$

also...
htmlcss=on and grid=off
seems to kill NOLEAD and also
puts a nasty empty row between the header and the body. Any ideas how to recapture NOLEAD and avoid this extra line?

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Roland

Gold member

posted

Hide Post

Susannah,

Just a guess:
try putting the drilldown specs into your first TYPE=DATA statement. Possibly it's a problem with the sequence WF is processing the stylesheet.

Posts: 54 | Location: Switzerland | Registered: May 13, 2003

Ignored post by Roland posted

Show Post

<JG>

posted

Susan, instead of using the column name for the COLUMN= use the N notation method for example

TABLE FILE CAR
SUM SEATS DEALER_COST
BY MODEL AS ''
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=DATA, FOCEXEC=CARINST,COLUMN=N2,$
TYPE=DATA, COLUMN=N2, BACKCOLOR=RED,WHEN=SEATS GT 3, $
TYPE=DATA, COLUMN=N2, STYLE=BOLD,WHEN=SEATS GT 3, $
TYPE=DATA, BORDER=1,BORDER-COLOR=SILVER,FONT='MS Sans Serif',SIZE=8,$
ENDSTYLE
END

Don't have a problem with NOLEAD but I'm running 5.33

posted

Susannah, as you may have gathered by now, the problem is not really with HTMLCSS, but with WebFOCUS styling itself - you cannot conditionally change the color of a column that has an HTML hyperlink on it.

Here is another example of what you may be able to do, using border colour.

TABLE FILE CAR
SUM
SALES
BY MODEL
BY COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, FONT='MS SANS SERIF',SIZE=8, $
TYPE=DATA, BORDER=1, BORDER-COLOR=SILVER, $
TYPE=DATA, COLUMN=MODEL, FOCEXEC=XXX(PARM1=1 PARM2=MODEL ), $
TYPE=DATA, COLUMN=MODEL, BORDER-COLOR=RED, WHEN=SALES LT 10000, $
ENDSTYLE
END[/code]Meanwhile, I'm looking into trying to do what you require, but using style within an -HTMLFORM.

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

<JG>

posted

Using the N column notation allows you to conditionally style the cell with the hyperlink.
Try it.

BCarter

Member

posted

Hide Post

Seems like we have a WF styling limitation here. You can either have a conditional drilldown OR conditional styling (font color), but not both. The problem is that we don't have specific styling for <a> tags (a color: red

, but instead attempt to style our hyperlinks with a CSS class on the TD tag. That's not good. I'll address this with our developers, but could really use a customer case to push this through. Susan, can you open a case, pretty please?

Thanks,
Brian

Posts: 22 | Registered: August 19, 2003

Ignored post by BCarter posted

Show Post

posted

Just cannot change the colour of the hyperlink.

TABLE FILE CAR
SUM
SALES
BY MODEL
BY COUNTRY
ON TABLE HOLD AS H001 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=MODEL, FOCEXEC=XXX(PARM1=1 PARM2=MODEL ), $
TYPE=DATA, COLUMN=MODEL, CLASS=HIGHLIGHT1, WHEN=SALES LT 10000, $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN

!IBI.FIL.H001;

-HTMLFORM END

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

susannah

Expert

posted

Hide Post

i have conditional color styling on my drilldowns now...all over the place, using the column name.
its only when HTMLCSS is ON that it goes haywire.
And the only reason HTMLCSS is ON is to get rid of that nasty GRID and replace it with a nice light line.
I'm going to now try everything all of you have suggested. Thanks so much...i'll report back..

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

posted

Can you show us how you got the conditional styling to work?

susannah

Expert

posted

Hide Post

you betcha
-SET &DD0 = 'THISFEX';
-SET &DD1 = 'NEWFEX';
TABLE FILE CAR SUM SALES SEATS AND COMPUTE REVENUE/D8=SEATS * DEALER_COST;
BY COUNTRY BY MODEL
ON TABLE SET STYLE *
TYPE=REPORT, BACKCOLOR=WHITE,FONT='ARIAL',SIZE=9,$
DEFMACRO=TURNBLUE,MACTYPE=RULE,
WHEN=REVENUE GT 20000 , $
TYPE=DATA,COLUMN=REVENUE,MACRO=TURNBLUE,COLOR=RED,$
TYPE=DATA,COLUMN=REVENUE,FOCEXEC=&DD0(COUNTRY=COUNTRY BODYTYPE=BODYTYPE),$
END[/code]Brian, okey doke...i'll open a case...this is the same issue we have all been asking for for ages...the inextricable combination of grid and wrap and the nasty things that grid on/off does to a report. Bless you for helping.

Pietro, you've taught me so much about conditional styling in the htmlform...i've tried what you suggest...but no cigar. I'll try again, with renewed zeal...

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

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

susannah

Expert

posted

Hide Post

PIETRO...once again to the rescue.
all i had to do was put TABLE {border-collapse: collapse; } into my final style tags and BINGO..the ugly grid goes quiet.
wow. thank you so much. you've just revolutionized my site.

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Show Post

posted

I LOVE the border-collapse style sheet tag!

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

style sheet question; conditional color w/htmlcss=on

Focal Point | Privacy Statement | Terms of Service