Is it possible in WF8 to format the background color of a cell based on the value of another cell.

Ex: TBLMSTR_MESSAGES contains two columns: MSSGNBR and MESSAGE. We want to Print the MESSAGE on a report but have the background color be GREEN if MSSGNBR=1 and red if MSSGNBR = 2. Can this be done?

How would I alter this code?


TABLE FILE TBLMSTR_MESSAGES
PRINT
TBLMSTR_MESSAGES.TBLMSTR_MESSAGES.MESSAGE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=TITLE,
COLUMN=N1,
BACKCOLOR='GREEN',
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END

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

WF style something like:

TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=GREEN, WHEN=MSSGNBR EQ 1, $
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=RED  , WHEN=MSSGNBR EQ 2, $

trying similar stuff...no effect?

DEFINE FILE TBLMSTR_MESSAGES
CONDSW/A1=IF MSGNBR EQ '2' THEN '1' ELSE '0';
END


TABLE FILE TBLMSTR_MESSAGES
PRINT
TBLMSTR_MESSAGES.TBLMSTR_MESSAGES.MESSAGE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=GREEN, WHEN=CONDSW EQ 1, $
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=RED , WHEN=CONDSW EQ 2, $
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END

quote:

TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=GREEN, WHEN=MSSGNBR EQ 1, $
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=RED , WHEN=MSSGNBR EQ 2, $

again...no effect:

DEFINE FILE TBLMSTR_MESSAGES
CONDSW/A1=IF MSGNBR EQ '2' THEN '1' ELSE '0';
END


TABLE FILE TBLMSTR_MESSAGES
PRINT
TBLMSTR_MESSAGES.TBLMSTR_MESSAGES.MESSAGE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=GREEN, WHEN=CONDSW EQ '1', $
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=RED , WHEN=CONDSW EQ '0', $
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

You have to specify the column that is used in the report WHEN clause :

DEFINE FILE TBLMSTR_MESSAGES
CONDSW/A1=IF MSGNBR EQ '2' THEN '1' ELSE '0';
END


TABLE FILE TBLMSTR_MESSAGES
PRINT
TBLMSTR_MESSAGES.TBLMSTR_MESSAGES.MESSAGE

CONDSW NOPRINT

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=GREEN, WHEN=CONDSW EQ '1', $
TYPE=DATA, COLUMN=MESSAGE, BACKCOLOR=RED , WHEN=CONDSW EQ '0', $
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

This message has been edited. Last edited by: Francis Mariani,

You need to also PRINT CONDSW.

Thank you!