nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

SQL Direct REport Conditional formatting on columns - OBIEE 11.1.1.7.151020

Morel Cornnery

Hi All ,

Am looking a way to use Conditional formatting features from analyses but the same is greyed out .

Please any one could advise me about how to do it ?

Thanks for your advice .

Regards ,

Morel

Find more posts tagged with

Accepted answers

All comments

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:

DDR screenshot.PNG

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 .