APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Coloring column in sql report

TexasApexDeveloperNov 2 2010 — edited Nov 9 2010

I have a weird question.. I am trying to color a color in a SQL based report. I am trying to imbed the color via a span and the report template seems to be overriding what I am doing in my select..

Apex 4.0 on a 10g XE demo machine
Under windows 7 enterprise..

select WORKSTATION_Fk||':'||DESCRIPTION Workstation,
MAX(( decode( val, '03:00 AM','<span style="color:red">' || a.Project_Id || '/span>', null ) )) am_3,
MAX(( decode( val, '04:00 AM', a.Project_id, null ) )) am_4,
MAX(( decode( val, '05:00 AM', a.Project_id, null ) )) am_5,
MAX(( decode( val, '06:00 AM', a.Project_id, null ) )) am_6,
MAX(( decode( val, '07:00 AM', a.Project_id, null ) )) am_7,
MAX(( decode( val, '08:00 AM', a.Project_id, null ) )) am_8,
MAX(( decode( val, '09:00 AM', a.Project_id, null ) )) am_9,
MAX(( decode( val, '10:00 AM', a.Project_id, null ) )) am_10,
MAX(( decode( val, '11:00 AM', a.Project_id, null ) )) am_11,
MAX(( decode( val, '12:00 PM', a.Project_id, null ) )) am_12,
MAX(( decode( val, '01:00 PM', a.Project_id, null ) )) am_13,
MAX(( decode( val, '02:00 PM', a.Project_id, null ) )) am_14,
MAX(( decode( val, '03:00 PM', a.Project_id, null ) )) am_15,
MAX(( decode( val, '04:00 PM', a.Project_id, null ) )) am_16,
MAX(( decode( val, '05:00 PM', a.Project_id, null ) )) am_17
from
(
select workstation_fk,Project_id,project_color,to_char(start_time,'HH12:MI AM') val
from GARTNER_PROCESSING_ITEMS GPRI 
  JOIN GARTNER_PROJECT_ITEMS GPI ON gpri.project_item_fk = gpi.PROJECT_ITEM_ID
  JOIN GARTNER_PROJECTS GP       ON gpi.PROJECT_FK = gp.PROJECT_ID
where workstation_fk is not null
group by workstation_fk,Project_id,project_color,to_char(start_time,'HH12:MI AM')) a,
GARTNER_WORKSTATIONS gw,GARTNER_PROJECTS GP
WHERE a.Workstation_Fk = GW.WORKSTATION_ID AND
      a.project_id = gp.project_id
group by WORKSTATION_Fk||':'||DESCRIPTION

My thought is the span should deliver the red font, but looking at the output through firebug there is none of the code I produce....

Thank you,

Tony Miller
Webster, TX