Re: Verifying print from Reports 2.5

Martin wrote:
>
> How about updating the indicator in the AFTER REPORT trigger - remember to
> commit.

This won't work, since the AFTER REPORT trigger also fires if the user closes the preview window without printing the REPORT. We've had the same problem and the only solution we've seen was to place a button into the REPORT's layout (it isn't printed) and to write a trigger for it.
The trigger sets a variable to a specified value and raises a PROGRAM ABORT(?) exception which then causes the AFTER REPORT trigger to execute. There you can read the variable and decide whether it is necessary to update the database or not.

>
> Mark Prebilic wrote in message <34E46F8C.2F298EC7_at_rocketmail.com>...
> >I need to find a way to verify that a user has printed a report that has
> >been generated by Oracle Reports 2.5. Specifically, the user wants us
> >to update the database with an indicator that says the report has been
> >printed when the user presses the 'OK' button in the Print dialog that
> >comes up after pressing the 'Print' button in the reports Previewer.
> >I'm thinking this is not possible, or if it is, it would involve some MS
> >windows programming. Can anyone help here? The report is run on a
> >Windows 95 OS against an Oracle 7.3 database on a UNIX server.
> >
  Received on Sat Feb 21 1998 - 00:00:00 CET