iReport – Adding MS SQL driver to iReport

iReport — Jeff Eske on July 27, 2011 at 9:06 am

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 machine, that folder was C:Program FilesJaspersoftiReport-4.0.2ireportlibs.  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

iReport – Jaspersoft iReport and MS SQL

iReport — Jeff Eske on July 27, 2011 at 8:53 am

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

pChart Looks Promising

Linux — Jeff Eske on July 21, 2011 at 4:24 pm

I’m needing to create some reports for use with our implementation of FrontRange’s ITSM product.  ITSM has reports available via Crystal Reports, but these aren’t dynamic.  To make things dynamic, I decided to create my reports directly out of the MS SQL database, using php.  The one issue was how to easily create charts from the data I pull back.  I’ve done some with GD in the past, but it wasn’t terribly easy and didn’t look that great.  After some investigation, it looks like pChart (http://www.pchart.net/) may be the ticket.  I’ve just started messing with it, so I don’t know how well it will work for sure, but it looks promising.

Learning Old-School Web Services

Programming,Web Stuff — Jeff Eske on July 21, 2011 at 2:06 pm

I’m in the process of bringing up a new version of ITSM (Version 7), and we have an outsourced call center that needs to be interfaced with it.   ITSM has old-school web services (SOAP) available, but they’re not terribly well documented.   Consequently, it’s given me a lot of reason to spend time pounding away learning how to implement web services.  It’s pretty interesting.  I’d like to dive in and learn more about REST APIs, but don’t know when I”ll have time.

Viewing ITSM Incidents and Tasks

ITSM — Jeff Eske on July 21, 2011 at 2:04 pm

I’ve started creating a web page that will give you a list of the ITSM Incidents/Tasks that you own or that are assigned to you.  It gives you a “read-only” view of the Incidents and Tasks and allows you to view them and navigate amongst them.  I envision it being useful mainly for techs out in the field.  This will allow them to be able to view their ticket information using only their phone.   It’s been tried on various smartphones, including Blackberry, iPhone, and various Android phones.  It also works on all of the other iDevices.   It displays in REALLY basic HTML, so it should work on virtually anything with a browser.

ITSM Team Incident and Task Viewing

ITSM — Jeff Eske on July 21, 2011 at 2:03 pm

I’ve started creating a web page that will give you a list of all of the ITSM Incidents/Tasks that are assigned to a team within ITSM.  It gives you a “read-only” view of the Incidents and Tasks for each team  member and allows you to view them in a new window.  It’s been tried on various smartphones, including Blackberry, iPhone, and various Android phones.  It also works on all of the other iDevices.   It’s displays REALLY basic HTML, so it should work on virtually anything with a browser.  I’m using PHP and directly querying the DB server to pull the appropriate information.  It may not be perfect, or the preferred method, but it’s quick and I understand it.

The Eskes get their 15 minutes of fame

General — Jeff Eske on July 21, 2011 at 12:45 pm

We made the local news here in Omaha.  WOWT Channel 6 did a piece on us, regarding foster care.  We were foster parents for a little over 3 years before adopting.  Nebraska has had an upheaval in the way it handles foster care, and I think that has soured some people on being foster parents so there’s a greater need for families to step up.  My wife and I never really encountered the problems that others did.  I guess we were lucky.

Anyway, the article is available at: http://www.wowt.com/home/headlines/A_Growing_Need_For_Fostering_Families_125790209.html

Jeff

 

 

 

Viewing ITSM Incidents and Tasks

ITSM,Programming — Jeff Eske on July 20, 2011 at 4:19 pm

I’ve started creating a web page that will give you a list of the ITSM Incidents/Tasks that you own or that are assigned to you.  It gives you a “read-only” view of the Incidents and Tasks and allows you to view them and navigate amongst them.  I envision it being useful mainly for techs out in the field.  This will allow them to be able to view their ticket information using only their phone.   It’s been tried on various smartphones, including Blackberry, iPhone, and various Android phones.  It also works on all of the other iDevices.   It displays in REALLY basic HTML, so it should work on virtually anything with a browser.

ITSM Team Incident and Task Viewing

ITSM,Programming — Jeff Eske on July 20, 2011 at 4:18 pm

I’ve started creating a web page that will give you a list of all of the ITSM Incidents/Tasks that are assigned to a team within ITSM.  It gives you a “read-only” view of the Incidents and Tasks for each team  member and allows you to view them in a new window.  It’s been tried on various smartphones, including Blackberry, iPhone, and various Android phones.  It also works on all of the other iDevices.   It’s displays REALLY basic HTML, so it should work on virtually anything with a browser.  I’m using PHP and directly querying the DB server to pull the appropriate information.  It may not be perfect, or the preferred method, but it’s quick and I understand it.

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License. | Jeff's Blog