Hi Friends,
I am trying to display my report with a checkbox having column value as 'Y' or 'N' in table.
My query is as below :
SELECT APEX_ITEM.CHECKBOX(1,advertised,'disabled=disabled;' ||DECODE(advertised,'Y','CHECKED', 'UNCHECKED')) "Advertised Flag"
FROM xyz;
Report is showing all the checkboxes as disabled and UNCHECKED irrespective of the ADVERTISED column value(Y or N).
Any suggestions what I am doing wrong in the query.
Thanks,
Raj.