RE: Web Reporting Tools

We are also looking at Jasper but are looking more at the purchased version than the open source. The open source does not have any easy end-user adhoc reporting but since you are not looking for that you could look at Jasper open source. There is also BRIT which is java based and if you're using Eclipse/WDSC/RDi for development in IT you may want to give that a try. I have not but have read about others who have. I think this is also open source. We are also using Clover from BCD as we already were a Websmart user.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James Rich
Sent: Monday, June 01, 2009 4:49 PM
To: Midrange Systems Technical Discussion
Subject: Re: Web Reporting Tools

On Mon, 1 Jun 2009, Charlie Prothero wrote:

Hello, everyone. We have yet to venture into web-based reporting, and I
have not seen any recent discussion on the topic here. We have an
academic ERP system (DB2/RPG) that does finances as well as student
information recordkeeping. Reporting is a sore point. We do not want a
data warehouse that copies the data on a scheduled basis and produces
stale reports. It's live, real time, or nothing. We anticipate that
most queries would be developed in IT and published for the users to
run, perhaps with some parm options.

I have seen lots of press on IBM Web Query, as well as competing apps
from independent software vendors. I would be very interested to hear
what you have chosen for your shop and what the deciding factor was.

I've been using jasperreports for this sort of thing. The deciding factor
was that it is all java and therefore portable across systems. It
produces HTML, PDF, CSV, and Excel output.

James Rich

if you want to understand why that is, there are many good books on
the design of operating systems. please pass them along to redmond
when you're done reading them :)
- Paul Davis on ardour-dev