View Full Version: Archiving Standard Reports

LawsonTalk > Reporting (NEW!!) > Archiving Standard Reports



Title: Archiving Standard Reports


LaurenSH - March 20, 2007 06:45 PM (GMT)
Am interested to know how companies store or archive std reports such as PR134, PR141, PR160, etc.

We are moving from 7.2.2.7 on iSeries to 9.0 on Windows. Currently use a product called LaserVault for report archiving; a process is set up that LV grabs certain reports from Print Manager and stores them. The reports remain in PM until users delete them (which rarely happens). Set-up is fairly simple for iSeries; looks more complex with Windows, and we're just looking for what others are doing.

What we're seeing with 9.0 is that a job run today with same job name as one run last week gets overwritten. Our Payroll users vastly prefer to work in the LID rather than in Portal. They don't want to have to re-name the PR141 etc every time they run it, and they probably don't want to switch over to Portal, open the report, and save to a different location for posterity either.

Any thoughts appreciated!
Lauren

schroncd - March 21, 2007 04:33 AM (GMT)
Some years ago I wrote a set of scripts on a Unix system which were called whenever a user sent a report to a "special" printer which archived and compressed the report for posterity. The "special" printer could also be included in distribution groups for automatic archival. We deleted unarchived reports from user's print managers after 15 days. Another script could retrieve archived reports and insert them back into Print Manager for viewing whenever they were required - of course they would be deleted again when the cleanup ran every night.

Users could also search for words or phrases inside the archived reports and receive a list of "hits" to choose from. Users found it very useful and since reports were saved by username with a date & timestamp extension they never had to worry about renaming their reports every time they ran them.

Of course this was in the days before Portal. It could probably be rewritten to use web forms as a front end though.

SAH - March 21, 2007 12:42 PM (GMT)
Hi Dave - hope all is well! Are these scripts possibly on your website? I'll look, but I'm being lazy....

Thanks

schroncd - March 22, 2007 02:01 AM (GMT)
Unfortunately not.. That one was WAY long time ago and it's lost in the mists of time.. Of course there's no reason I couldn't rewrite it if I can get the time.

I'll let ya know if I can wring one out of my tired old brain.




Hosted for free by InvisionFree