Report Triggers

To extend report writing capabilities, An Oracle Reports Builder enables the use of PL/SQL code blocks.  PL/SQL constructs can be used to perform the job if conditional logic in required in a report.

Examples

If a sales value is below the specified goal, then such sales values can be shown with a various text color. That will helps you to draw attention to these values.

PL/SQL code blocks can be used in various categories of triggers that are available in Oracle Reports:

1.    Formula Triggers
2.    Formula Triggers
3.    Action Triggers
4.    Validation Triggers
5.    Report triggers
6.    Groups Filters

Every of them is explained below: