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
Integration Between OTRS and Jasper Reports
Moderator: crythias
Re: Integration Between OTRS and Jasper Reports
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.
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.
Backend: OTRS 3.0.11 RedHat Enterprise Linux 6.2, Apache, MySQL with replication
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
Re: Integration Between OTRS and Jasper Reports
Hi,
it would also great if you file some of your SQLs for reporting here: http://wiki.otterhub.org/index.php?titl ... generators
it would also great if you file some of your SQLs for reporting here: http://wiki.otterhub.org/index.php?titl ... generators
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 35
- Joined: 07 May 2012, 19:56
- Znuny Version: OTRS 3.0
- Real Name: Natalia King
- Company: Lyons Consulting Group
- Location: Chicago, Illinois
- Contact:
Re: Integration Between OTRS and Jasper Reports
I do not really understand this part
Would appreciate any help to understand this syntax betterPlease adjust the ${INTERVAL} part to your needs.
OTRS 3.0, CentOS 5.5
Re: Integration Between OTRS and Jasper Reports
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
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
Backend: OTRS 3.0.11 RedHat Enterprise Linux 6.2, Apache, MySQL with replication
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL
Frontend: OTRS 3.0.11 RedHat Enterprise Linux 6.2 with SELinux, Apache SSL