<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'>Dear Benjamin,<br><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000"><br>Thanks for all the hard work.<br><br>I have in fact played with Jasper and RT before.<br><br>I gave up as the reports I was trying to generate were to do with time worked.<br><br>RT seems to have two different places where time is recorded and calculated, and so querying the DB gets complicated.<br><br>Does your integration of Jasper with RT make this clearer / easier?<br><br>or do you have any example SQL queries for reporting on Time worked in RT?<br><br>Thanks so much,<br><br>Alex<br><br><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Benjamin Boksa" <mailinglists@boksa.de><br><b>To: </b>"Albert Shih" <Albert.Shih@obspm.fr><br><b>Cc: </b>rt-users@lists.bestpractical.com<br><b>Sent: </b>Thursday, 26 April, 2012 10:59:37 PM<br><b>Subject: </b>Re: [rt-users] Announcing RT-REST and RT-Jasper [was: RT and JasperReports Server Integration (got it working, anyone interested?)]<br><br>Hi Albert,<br><br>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).<br><br>Regarding your questions:<br><br>1) See the private mail I sent you.<br>2) No.<br><br>If you have further questions just let me know.<br><br>Greetings from Cologne<br><br>Benjamin<br><br><br><br><br>Am 26.04.2012 um 21:28 schrieb Albert Shih:<br><br>> Le 22/04/2012 ? 19:11:23+0200, Benjamin Boksa a écrit<br>> Hi.<br>> <br>>> <br>>> it's done :-) I have setup two GitHub repositories to host everything you need to run you own RT an JasperReports Server integration:<br>>> <br>>> <br>>> RT-REST: http://projects.boksa.de/RT-REST/<br>>> RT-REST is a Java class library to interact with RT: Request Tracker's REST Interface.<br>>> <br>>> RT-Jasper: http://projects.boksa.de/RT-Jasper/<br>>> RT-Jasper is a toolkit to integrate RT: Request Tracker as a queryable data source in JasperServer.<br>>> <br>>> <br>>> 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<br>>> <br>>> http://sourceforge.net/projects/jasperserver/files/JasperServer/JasperServer%204.5.0/JasperReports-Server-CP-Install-Guide.pdf/download .<br>>> <br>>> To help you with your questions I'll try to be around in #rt on irc.perl.org .<br>>> <br>>> 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.<br>>> <br>>> Enjoy the rest of your weekends :-)<br>>> <br>> Big thanks for your works.<br>> <br>> Two questions before I spend lot of time to understand your works : <br>> <br>> 1/ What kind of reports can we have (I never heard of jasper, only<br>> the city in Canada ...;-) ). I didn't find your demo jasperserver<br>> ...:-(<br>> <br>> 2/ Is they are anything to modify on the RT server ? <br>> <br>> thanks again.<br>> <br>> Regards.<br>> -- <br>> Albert SHIH<br>> DIO bâtiment 15<br>> Observatoire de Paris<br>> 5 Place Jules Janssen<br>> 92195 Meudon Cedex<br>> Téléphone : 01 45 07 76 26/06 86 69 95 71<br>> xmpp: jas@obspm.fr<br>> Heure local/Local time:<br>> jeu 26 avr 2012 21:25:37 CEST<br>> <br><br></div><br></div></div><br></div></body></html>