SQL Direct REport Conditional formatting on columns - OBIEE 11.1.1.7.151020

Morel Cornnery

Thanks for the clarification Christian, So let me try to use  HTML in my sql statement .

Joel Acha

So you'd have to build your SQL statement for your DDR report. An example with pseudo code is:

SELECT

CASE WHEN column1 = 'ABC' THEN '<FONT COLOR="#00FF00">' || column1 || '</FONT>' ... END column1name,

CASE WHEN column2 = 'ABC' THEN '<FONT COLOR="#00FF00">' || column2 || '</FONT>' ... END column2name

FROM tablename

Morel Cornnery

Thank you to all !  works now Just happy to have advice from  oracle's Experts .

@Christian Berg Now I can close the thread as advised .