Integration Between OTRS and Jasper Reports

[gulas]

Hello Everyone,

Can say if its possible integrate otrs with jasper report ??

i recently installed jasper reports, configured successfully to connect with my OTRS BD, created reports according to my needs, and everything worked well.
i want to know if its possible to get this reports inside OTRS stats or something else. If its possible, how can i do this?

Thanks

[CSL]

I think if you've got this working well with Jasper reports then that should be enough - trying to create the same thing inside OTRS using the stats module will only lead to frustration and headaches (have been there and tried it myself).

The conclusion I came to was that using an external tool (Jasper, SQL Wabit etc) with custom-written SQL queries is far more flexible and far easier than writing a static stats perl file for OTRS.

[jojo]

Hi,

it would also great if you file some of your SQLs for reporting here: http://wiki.otterhub.org/index.php?titl ... generators

[nking]

I do not really understand this part

Please adjust the ${INTERVAL} part to your needs.

Would appreciate any help to understand this syntax better

[CSL]

I don't understand that either. It seems to be a call to a subroutine DATE_SUB that isn't defined on that page or anywhere in the file.

I'd Ignore it and put in your own date interval instead:
http://dev.mysql.com/doc/refman/5.5/en/ ... tions.html

I use lines like these in my queries to return data from a certain amount of time in the past:

AND st.create_time <= NOW()
AND st.create_time >= NOW() - INTERVAL 6 MONTH