Spool a report file in the Background [message #317558] |
Thu, 01 May 2008 23:05  |
jack_chessire
Messages: 5 Registered: April 2008
|
Junior Member |
|
|
Is there a way to spool a file without the user seeing it?
I'm in a situation where, whenever I update a row in one of the tables I have, I'd like for a new report file to be generated to reflect said change.
However, I don't want the user to see the report being generated. is there a way to do this?
|
|
|
|
|
Re: Spool a report file in the Background [message #317727 is a reply to message #317558] |
Fri, 02 May 2008 16:11  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
What do you plan to do with all these reports? View them one by one? Wouldn't you rather consider some other kind of auditing? If not "true" auditing, perhaps a simple "history" table populated by a database trigger; you could then view contents of this table and see what was happening in a much simpler manner than searching through bunch of report files (by the way, if your operating system doesn't allow versioning, new report version might overwrite the old one unless you add some kind of a unique identifier (timestamp, sequence, ...) to a report name).
|
|
|