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
That query gives me the results of the attached file,
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, refraining from coming on here and asking with no solution in sight.