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 - [EMAIL PROTECTED] Used for mailing lists - sporadic response _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
