RE: Producing reports from data result sets
- From: "Bill Coulam" <bill.coulam@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Dec 2004 15:40:41 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Boivin, Patrice J
Sent: Tuesday, December 07, 2004 9:07 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
