Yang Xie wrote:
>
> We have CA-ManMan running on HP3000. We run lots of ManMan reports and
> use Quiz to write lots of report too. I am going to take a project
> putting all those reports on our intranet (certainly I have to design
> intranet too). Any one out there can shed some lights on how to make
> those reports be shown in browser? Your attention is very much
> appreciated!

I am running a similiar course as yourself.  My daylight hours are spent
in a Manman shop.  We are currently spending the majority of our time
working on an internet/extranet project in which we are extending OMAR
directly to our customers and sales reps via an extranet.  Our customers
will be doing their own TR,100's via html forms, eventually applets.

Due to the internet/extranet project, our intranet/app server has taken
a backburner.  Currently it is quite basic - Human Resources stuff.
However, I have done a great deal of expirementation with Java
servlets/ADBC/JDBC.  One item that I have done in the meantime to hold
us over is to use Java and an ADBC beta to read spoolfiles from our
HP3000, and then use java.util.zip.* classes to push a number of these
spoolfiles into one zip file.  You wouldn't believe how much "report"
data can fit onto one floppy disk.  We place these zip files into
various shared directories on our Novell and NT servers.  All that is
needed to view the reports is Winzip.  Our monthly UT,801 transaction
log reports used to take a case and a half of paper(~5 trees) to print.
Today it was ~900K zipped.

If you are interested in seeing the code, send me an e-mail offline and
I will send it to you.  This code could be easily altered to be placed
into a servlet and written to the http response outputstream instead of
a zip outputstream.

Also, I might be opening myself to scrutiny here, but you might want to
consider creating Java applets/applications to view reports in.  The
most recent version of the Java Developers Kit JDK1.2( 2.0 ) contains
the Java Foundation Classes, dubbed "Swing", which is a number of very
useful visual components, including HTML readers/parsers, that report
data can be viewed through.  You have more control of your data than you
would with a browser.  If you are viewing large reports via a phone line
the data can be compressed/zipped on the app/web server and then
decompressed/unzipped and viewed on your client.  Sun has created a
JDK1.2 plugin for Netscape and IE.

My .00 worth.

Evan Vaala
Electro-Craft