Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Producing reports from data result sets

RE: Producing reports from data result sets

From: Bill Coulam <bill.coulam_at_scgo.com>
Date: Tue, 7 Dec 2004 15:40:41 -0600
Message-ID: <FJEOLLFBELDPHAFFABKMGEMMCCAA.bill.coulam@scgo.com>


A little more context would be helpful. For example,

You mention jsp and servlet. So I assume the SQL queries you speak of refer only to SQL statements processed by JDBC calls within the servlets. Amend if incorrect.

How big are the result sets? How often are they requested? Caching needed? Must the reporting be web-based like the application?

Number of users? Location of users? Need for paging, graphing and other features your users got used to? New features they'd like to have? How do they use the output data (many immediately import to Excel where they can have their way with it)?

Does this apply to a single in-house application, or many?

Possibilities you've considered. Alternatives already rejected. Openness to open-source.

The "easy" way and easy answer is to install SQL*Plus or iSQLPlus and let the users run scripted and ad-hoc SQL, with little or no formatting. But I 'spect that won't fit your needs.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Boivin, Patrice J Sent: Tuesday, December 07, 2004 9:07 AM To: oracle-l_at_freelists.org
Subject: Producing reports from data result sets

One of the developers approached me, she is looking for an "easy" way to produce reports from SQL query output.

We previously were using a 3rd party component to do this but we want to move on.

At this point we don't want to use Oracle Reports for this application.

It uses jsp pages and runs as a servlet.

Patrice.
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 07 2004 - 15:37:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US