The order of events when a report is executed is as follows:
Before Parameter Form trigger is fired.
1. Runtime Parameter Form appears (if not suppressed).
2. After Parameter Form trigger is fired (unless the user cancels from the Runtime
3. Report is "compiled."
4. Queries are parsed.
5. Before Report trigger is fired.
6. SET TRANSACTION READONLY is executed (if specified via the READONLY
argument or setting).
7. The report is executed and the Between Pages trigger fires for each page except the last one
(Note that data can be fetched at any time while the report is being
formatted) COMMITs can occur during this time due to any of the following
user exit with DDL, SRW.DO_SQL with DDL, or if ONFAILURE=COMMIT,
and the report fails.
8. COMMIT is executed (if READONLY is specified) to end the transaction.
9. After Report trigger is fired.
10. COMMIT/ROLLBACK/NOACTION is executed based on what was specified via
the ONSUCCESS argument or setting.