Re: HTML and PDF Reports

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

What about doing a Data Warehouse/Data Mart/Operational Data Store in another LPAR, if possible, have the users create their own reports with IBM DataQuant and DB2 Query Manager, or some such tools for interactive and batch reporting, and get yourself out of the report generation business as much as possible?  That what I'm doing here.
 
Dave Odom
Arizona


> > > Nathan Andelin <nandelin@xxxxxxxxx> 5/12/2008 13:08 >>>
> Brad Stone wrote:
> Why wouldn't you just create dynamic reports to begin with?
> No need to really store that data/report if the data is already
> in the database.

It depends on the application, though I understand the need to support dynamic queries.

What I've had in mind lately are printer friendly snapshots of the database at a particular instance, and useful for historical purposes, as data may change from one moment to the next, be migrated to a different platform, or even purged.  In that event, users may need to refer back to formatted stream files, perhaps stored on an archive server, or optical media.

> Making printer friendly versions is as easy as applying a new CSS.

I think it would be helpful if you explained further.  And would applying a new CSS take into account the call for page-ejects according to data groupings?

--
Nathan M. Andelin


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ