Oracle Application Express (MOSC)

MOSC Banner

Need to Conditionally Set Cell Background in Classic Report

edited Jan 26, 2012 2:43AM in Oracle Application Express (MOSC) 10 commentsAnswered ✓
 We have a requirement that certain cells be color coded depending on some complex conditions. 
I have the logic done to determine the color to which each cell should be set. However, I am unable to figure out how to plug this into APEX.

So far, I have a query that returns the columns form a view. In addition, computed columns exist that determine the desired color of the cell. For example:

CASE 
   WHEN ( SYSDATE - RUNTIME ) > 1 THEN 'Red'
   WHEN (SYSDATE - RUNTIME ) > .5 THEN 'Yellow'
   ELSE 'Green'
END AS RUNTIME_BG

In APEX, I set these computed field to not show. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center