Dear Bas, the only sophisticated SQL report sequence I have and use is:
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 year(t.create_time) = '2006' GROUP BY t.create_by This gives you the total time units for each user. I am very much interesting in using JasperReports with OTRS, but I have trouble to create useful template. The connection to the database is working, but I can't get the templates to show the things I need (e.g. amount of request by customers or by customerID and so) If somebody already has knowledge in this field, please share. I think many people want to expand the usage of the stats modul by using Jasper or other Reporting engines. Best Regards, Andreas Plaul -- This message has been scanned for viruses and malicious content by TUV Rheinland Japan's perimeter scanner, and is believed to be clean.
_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/
