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

    Changing font color in a report using SQL query

    xarg-Xrc
      Hi,

      I am trying to change the font color based using a CASE statement the query as below:
      select "ORDER_ID", 
      "ORDER_REFERENCE",
      "ORDER_DATE",
      "ORDER_SOURCE",
      "TOTAL_DISCOUNT",
      "DELIVERY_TYPE",
      "PICKUP_DATE",
      case
           when order_status = 1 then '<font color="red">'|| order_status||'</font>'
           else
           '<font color="blue">'||order_status||'</font>'
      end order_staus,
      "DELIVERY_STATUS",
      "USER_ID",
      "CUSTOMER_ID",
      "SITE_ID"
      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.

      Environment

      Apex 4.1.1 at apex.oracle.com
      Theme 13

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