Oracle Application Express (MOSC)

MOSC Banner

Oracle APEX (Advanced) - Highlight row based on condition

edited Sep 6, 2012 7:39PM in Oracle Application Express (MOSC) 1 commentAnswered
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 image



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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center