I used the query below in interactive report and turned escape special characters off. This is just coloring text whereas requirement is to highlight entire row.
I wish to highlight the entire row based on column values. So when Statu=Open, row should get highlighted in green and so on..
Any suggestions?
Ex: SELECT "P_IT_ISSUES"."ISSUE_SUMMARY" as "ISSUE_SUMMARY", decode("P_IT_PEOPLE_1"."PERSON_NAME",NULL,'Unassigned', "P_IT_PEOPLE_1"."PERSON_NAME") as "ASSIGNED_TO",
case when "P_IT_ISSUES"."STATUS" ='Open' then '<aaab style= " color: green; " >'
||"P_IT_ISSUES"."STATUS"||'</aaab>'
when "P_IT_ISSUES"."STATUS" ='On-Hold' then '<aaab style= " color: red; " >'
||"P_IT_ISSUES"."STATUS"||'</aaab>' else '<aaab style= " color: red; " >' ||"P_IT_ISSUES"."STATUS"||'</aaab>' end "Status"
FROM "P_IT_PEOPLE" "P_IT_PEOPLE_1", "P_IT_DEPARTMENTS" "P_IT_DEPARTMENTS", "P_IT_PEOPLE" "P_IT_PEOPLE", "P_IT_ISSUES" "P_IT_ISSUES" WHERE "P_IT_ISSUES"."IDENTIFIED_BY_PERSON_ID"="P_IT_PEOPLE"."PERSON_ID" AND "P_IT_ISSUES"."ASSIGNED_TO_PERSON_ID"="P_IT_PEOPLE_1"."PERSON_ID"(+) AND "P_IT_ISSUES"."RELATED_DEPT_ID"="P_IT_DEPARTMENTS"."DEPT_ID"