Have you tried otrs-manager ? version 0.5.1 generates a agent/ticket table stat in word, there should be easy applying a vbmacro to create a grafical stat one, this could just an option with it.
the link to that tool: otrs-manager.sourceforge.net/index.php?page=homepage_en On Thu, Aug 14, 2008 at 9:08 AM, John (yt) Hogenmiller <[EMAIL PROTECTED]> wrote: > 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/ > -- Marco Vannini home: +39 02 900091454 mobile: +39 335 5340819 msn: [EMAIL PROTECTED] talk: [EMAIL PROTECTED] icq: 58389316 skype: marco69v _______________________________________________ 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/
