I have built a reporting system in JSP.
Basically it is stored procedure driven. Then I have a series of Beans to
process the data.I have second series of beans responsible for the
formating. Then output the report in simple html format.
The nice thing with stored procedures driving the core, it makes it easy to
update and add reports to the system.
The problems with web reporting systems is data load. People seem to always
want to take the old 1000 page reports and port them them to the web, or
have several million records where processing time wont work without also
building a special pre-processed reporting database.
Keep in mind web reports need to run quick and under 5 minutes.
It doesn't matter if the old report took a half hour on the old system. With
web report
people expect speed, and if they dont get it they get mad. Be forewarned...
Oh well so it goes.
Over time I am going to build my reporting feature in the jspkit found on
the www.jspinsider.com web site so you can check that out. Right now the kit
is very beta and is just a framework which we will expand to have more
reporting capability using beans and tag libraries.
Right now I am experiementing with outputing the report data in XML and then
using style sheets to do the special formating. In a few months I will have
a good handle if this is a good way to go.
Casey Kochmer
[EMAIL PROTECTED]
>From: Brian Nice <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: JSP and Reports
>Date: Tue, 24 Oct 2000 22:08:39 -0400
>
>What is the best way to generate complex reports from JSP? I was =
>thinking about selecting the information for the report out of the =
>database in XML format and then applying a style sheet to the XML data =
>to convert it into PDF format. Nice, but for complex reports the style =
>sheets becomes unbearable.
>
>Are there ways to interface with Crystal Reports or some other reporting =
>program so that the user can click on a link on a web page to have a =
>report generated and then displayed to the user. Also the user should be =
>able to print the report to their printer.
>
>What are the best ways to accomplish something like this?
>
>Thanks in advance
>Brian
>[EMAIL PROTECTED]
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
