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.