Everyone likes pictures. I would never create a report that didn’t have at least one chart in it. You just can’t risk busy people glancing at your reports and not coming away with the key information you’re trying to impart.
We have lots of chart types in SQL Developer – 50+ in version 4.0.
But we also have gauges, and I’ve talked about them before.
But what about dials?
So we can graph numbers, but how do we know if a number is ‘high’ or not?
To define our gauge, set the gauge style to ‘Dial.’
SELECT SUM(salary) VALUE, 10000 MIN, 400000 MAX, 45000 LowThrs, 175000 HiThrs FROM hr.employees WHERE department_id = :DEPARTMENT_ID
I still think Reports are one of our most under-utilized features in the tool. Would you call it a ‘must have’ one?