iReport – Jaspersoft iReport and MS SQL

Posted on July 27, 2011

I’m in the process of creating reports for FrontRange ITSM, here at work.  To this point, I’ve been developing charts with PHP/GD.  I found a very good PHP charting class out there ( http://www.pchart.net ) but am going to try something more suited to reports.  I’m giving Jaspersoft iReport a try.   One problem – by default, iReport doesn’t ship with a driver that allows me to connect to the Microsoft SQL (MS SQL) server that I need to connect to.  In addition, the documentation that I could find sucked.

It actually turned out to be pretty simple to add support for MS SQL.  I went out to the JTDS site (http://jtds.sourceforge.net/ and downloaded the zip file with the necessary jar file in it.  I then copied jtds-xxx.jar in the the libs folder in iReport.  On my Windows machine, that folder was C:\Program Files\Jaspersoft\iReport-4.0.2\ireport\libs.  On my linux machine, I left the iReport folder in my home folder, so the location was /home/my_home_folder/iReport/ireport/libs.  At that point, I had the jar file in the right place, but iReport didn’t know about it.  Once you’ve copied the jar file to the correct place, you need to start iReport and go to Tools > Options > iReport > Classpath and click on “Add JAR”.  Navigate to the jar file that you just added and click “Open”.  OK out of all of that and restart iReport.  At that point, when you go in to add a connection, that driver should show up.

UPDATE 10/24/2012 – You’ll need to be careful when upgrading iReport also.

Jeff Eske

Filed Under iReport | 1 Comment

Leave a Comment

If you would like to make a comment, please fill out the form below.

You must be logged in to post a comment.

© Copyright Jeff's Blog • Powered by Wordpress • Using Detour theme created by Brian Gardner.