RE: Web Reporting Tools

Hi John

Just to clarify - did you use the SQL Server Reporting Services over data
resident on the i ? Can you provide some details on what approach you used
to make that work ?

Regards
Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Taylor
Sent: Tuesday, 2 June 2009 8:59 a.m.
To: 'Midrange Systems Technical Discussion'
Subject: RE: Web Reporting Tools

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.

SQL Server Reporting Services.

Why? Because it's included as part of SQL Server, which we run anyway, so it
was "free" and readily available to play with. Once I got the hang of it, I
was producing nicer reports in a fraction of the time it would take to
produce an inferior result using RPG.

I've never tried IBM Web Query, so I can't compare the two for you. I'm very
happy with SSRS, and see no reason to spend lots of cash on IBM Web Query or
one of the third party apps.