Oracle APEX (Advanced) - Highlight row based on condition
I have this query on a classic report
SELECT w.vendor, w.qty, r.rec FROM (SELECT vendor, SUM(ord) AS qty FROM wag where ship_date = :P0_DATE GROUP BY vendor) w, (SELECT vendor, SUM(ord) AS rec FROM recinc where "sDATE" = :P0_DATE GROUP BY vendor) r WHERE w.vendor = r.vendor ORDER BY vendor
I want to highlight rows where the "Ordered" and "Received" column do not match
12 and 12 would not be highlighted
12 and 10 would be highlighted.
I am looking for someone to walk me through the process, i have been researching for a couple of days now and have not found a solid solution. any help would be greatly appreciated.
0