|
Re: Report successfully generated or not [message #457349 is a reply to message #457339] |
Mon, 24 May 2010 01:19 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I didn't try, but - take a look at SRW.GETERR_RUN built-in.
Reports Help
This function returns an error message if Reports Builder detects an error while running the SRW.RUN_REPORT procedure.
If I got it right, it means that you should, actually, run a report from another report (as SRW built-in package is available in Reports, not in Forms).
Other than that, maybe you could place flagging procedure into the After Report trigger. This trigger fires regardless the report completed successfully or not, but Reports Help says Reports Help
You can raise a message, though, to indicate that the report did not run correctly. For example, you could put the system time in a variable in the Before Report trigger and then compare it against the system time in the After Report trigger. If the report took longer than a certain time to run, you could raise an error.
I can't think of anything else at the moment.
|
|
|
|
|