Conditionally Text Color Change On Oracle Apex Interactive Report

Topic Introduction: In this tutorial, we change text color based on the condition of the oracle interactive report. This condition will be set on SQL query. to see details you can see this video or follow the work description of this post.

01. Create an Interactive Report using below SQL format. with AGING_COL column.

Report Query:

select EMPLOYEE_ID,

       FIRST_NAME,

       LAST_NAME,

       EMAIL,

       PHONE_NUMBER,

       HIRE_DATE,

       JOB_ID,

       SALARY,

        (CASE

         WHEN SALARY <= 5000 THEN 'RED'

         WHEN SALARY  >= 10000 THEN 'YELLOW'

         ELSE 'GREEN'

         END ) AGING_COL

  from OEHR_EMPLOYEES;

02. Go to the column property which column text want to change and write this HTML code on the HTML Expression box. 

Formatting Code: 

Column Formatting

HTML Expression:

<span style="color:#AGING_COL#"><b>#SALARY#</b></span>