A script-enabled browser is required for this page to function properly.

Before Report trigger

The Before Report trigger fires before the data is fetched and the report is executed but after the queries are parsed.

Definition Level

Report

On Failure

Displays an error message and then returns to the place from which you ran the report. 

Execution

The Before Report trigger fires before the report is executed but after the queries are parsed.

You can think of order in this way:

  1. Queries are parsed.

  2. Before Report trigger fires.

  3. Report is executed (that is, fetch data+format output)

Consistency is guaranteed if you do DML and DDL in (or before) the After Parameter Form trigger.  It nondefault be guaranteed in the Before Report trigger, since Reports Builder may have to start some work on data cursors before that trigger based on the definition of the report. One thing Reports Builder always does before the Before Report trigger is to describe the tables involved and open cursors. Any change to the tables after that will not be seen by the report.

See also

About triggers

About report triggers

Creating a report trigger

Deleting a report trigger

About DML and DDL