Conditionally Display Icon Column in Interactive Report

 

Step-1:

SQL Query :

select ID, NAME,  COUNTRY,  CITY, PHONE,
       STATUS,
      DECODE(STATUS, 1, 'fa fa-check-circle', 'fa fa-times-circle') icon,
      DECODE(STATUS, 1,  'green', 'red') icon_color

  from SETUP_EMPLOYEES;

Step-2:

Select STATUS Cloumn ---> HTML Expression

<span class="#ICON#" style="color: #ICON_COLOR#"></span>