alex at itworx
Apr 27, 2012, 3:09 AM
Fwd: Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]
Thanks for all the hard work.
I have in fact played with Jasper and RT before.
I gave up as the reports I was trying to generate were to do with time worked.
RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated.
Does your integration of Jasper with RT make this clearer / easier?
or do you have any example SQL queries for reporting on Time worked in RT?
Thanks so much,
----- Forwarded Message -----
From: "Benjamin Boksa" <mailinglists [at] boksa>
To: "Albert Shih" <Albert.Shih [at] obspm>
Cc: rt-users [at] lists
Sent: Thursday, 26 April, 2012 10:59:37 PM
Subject: Re: [rt-users] Announcing RT-REST and RT-Jasper [.was: RT and JasperReports Server Integration (got it working, anyone interested?)]
you can generate any kind of reports supported by JasperReports Server. RT-Jasper provides the DataSource necessary to query RT for tickets (the ticket's data can be used in the reports).
Regarding your questions:
1) See the private mail I sent you.
If you have further questions just let me know.
Greetings from Cologne
Am 26.04.2012 um 21:28 schrieb Albert Shih:
> Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit
>> it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration:
>> RT-REST: http://projects.boksa.de/RT-REST/
>> RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface.
>> RT-Jasper: http://projects.boksa.de/RT-Jasper/
>> RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer.
>> Feel free to give the components a try and let me know what you think :-) I have chosen to drop full installation instructions in favor of a demo system (see the RT-Jasper page for more information) and I assume you already have a RT installation to play with. To learn how to install JasperReports Server please refer to
>> http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download .
>> To help you with your questions I'll try to be around in #rt on irc.perl.org .
>> I am really curious to see what you will say about my work and I hope there will be enough users using it to ensure a constant flow of great ideas and improvements.
>> Enjoy the rest of your weekends :-)
> Big thanks for your works.
> Two questions before I spend lot of time to understand your works :
> 1/ What kind of reports can we have (I never heard of jasper, only
> the city in Canada ...;-) ). I didn't find your demo jasperserver
> 2/ Is they are anything to modify on the RT server ?
> thanks again.
> Albert SHIH
> DIO bâtiment 15
> Observatoire de Paris
> 5 Place Jules Janssen
> 92195 Meudon Cedex
> Téléphone : 01 45 07 76 26/06 86 69 95 71
> xmpp: jas [at] obspm
> Heure local/Local time:
> jeu 26 avr 2012 21:25:37 CEST