[otrs] report of time per agent // outside reporting

Ok, So if I go into the SQL box and run a query, I can pull up how many "work units" each agent accumulated in the current month: SELECT t.create_by, u.first_name, u.last_name, Sum(t.time_unit) FROM time_accounting AS t Left Join system_user AS u ON t.create_by = u.id WHERE month(t.create_time) = '08' AND year(t.create_time) = '2008' GROUP BY t.create_by However, for the life of me, I don't see how to create a report showing the same. So I'm looking for any report gurus out there or some good documentation/howtos on the subject. Also, has anyone gone into using an outside program to pull reports from OTRS (like Crystal Reports or DataVision)? -John -- John Hogenmiller - ytjohn@gmail.com Used for mailing lists - sporadic response