× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.