7 Replies Latest reply on Jun 3, 2012 2:47 PM by xarg-Xrc

    Changing font color in a report using SQL query


      I am trying to change the font color based using a CASE statement the query as below:
      select "ORDER_ID", 
           when order_status = 1 then '<font color="red">'|| order_status||'</font>'
           '<font color="blue">'||order_status||'</font>'
      end order_staus,
      from "ORDERS" 
      I can get this to work by selecting Standard Report Column in the column heading type. However this mean I can't use LOV as LOV options involve removing HTML characters.

      Is there a way I can conditionally change the font with query above and use LOV as well? Thanks.


      Apex 4.1.1 at apex.oracle.com
      Theme 13

      Edited by: taepodong on Jun 3, 2012 7:28 AM