I am looking for a high-end PC-based report writer to replace the relational one we
have now.
Daily, we extract data from our proprietary database to Oracle. We then want to
produce our reports from the Oracle database. The reports we want to produce have
detailed data and summaries on the same page, where the summaries are a pretty
different cut at the same data. In SQL, this requires two separate Select
statements. The tools I have seen so far cannot handle more than one Select
statement on the same page of one report.
The ideal report writer would be usable by non-technical end users who are familiar
with the application and the database. It would also be programmable in the sense
that a programmer could write a procedure to display a parts explosion, put an
unrelated summary field in a footer for comparison purposes, or produce a calendar
of upcoming events by reading scheduling fields which say, e.g., "daily at 07:00".
I am especially looking for input from folks with knowledge of object-oriented
report writers, not because OO is a buzzword, but because our proprietary database
is an object/network hybrid. Even though we have managed to express it
relationally, which seems a good lowest common denominator for reporting purposes,
the data content makes much more sense if you think of it in network or even OO
terms.
Vendor solicitations invited. Thank you.
--
Tim Spellman | IntraNet, Inc. is a leading provider of funds
TSpellman_at_IntraNet.com | transfer systems to financial institutions.