Oracle Reports

Matrix:

      A Matrix (Cross Tab) report contains one row of tables, one column of labels and information in grid format that is related to the row and column labels. A distinguished feature of matrix report is that the number of columns is not known until the data is fetched from the database. To create a Matrix report, at least four groups are required. One group must be cross-product group, two of the groups must be with in the cross product group to furnish the labels, and at least one group must provide the information to fill the cells. The groups can provide to a single query or to multiple queries.

Matrix with Group:

      A matrix with group report is a group above report with a separate matrix for each of the master group.

Matrix Report:

      To create a matrix report, you need at least four groups: one group must be a cross-product group, two of the groups must be within the cross-product group to furnish the "labels," and at least one group must provide the information to fill the cells. The groups can belong to a single query or to multiple queries.

The order of events when a report is executed is as follows:

  1. Before Parameter Form trigger is fired.
  2. Runtime Parameter Form appears (if not suppressed).
  3. After Parameter Form trigger is fired (unless the user cancels from the Runtime Parameter Form).
  4. Report is "compiled."
  5. Queries are parsed.
  6. Before Report trigger is fired.
  7. SET TRANSACTION READONLY is executed (if specified via the READONLY argument or setting).
  8. 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.
  9. COMMIT is executed (if READONLY is specified) to end the transaction.
  10. After Report trigger is fired.
  11. COMMIT/ROLLBACK/NOACTION is executed based on what was specified via the ONSUCCESS

Triggers in Reports and Sequence:

  • Before Parameter Form
  • After Parameter Form
  • Before Report
  • Between Pages
  • After Report

Before Parameter Form:

      Before Parameter Form Fires before the Runtime Parameter Form is displayed. From this trigger, you can access and change the values of parameters, PL/SQL global variables, and report-level columns. If the Runtime Parameter Form is suppressed, this trigger still fires. Consequently, you can use this trigger for validation of command line parameters.

After Parameter Form:

      After Parameter Form Fires after the Runtime Parameter Form is displayed. From this trigger, you can access parameters and check their values. This trigger can also be used to change parameter values or, if an error occurs, return to the Runtime Parameter Form. Columns from the data model are not accessible from this trigger. If the Runtime Parameter Form is suppressed, the After Parameter Form trigger still fires. Consequently, you can use this trigger for validation of command line parameters or other data.

Before Report:

      Before Report Fires before the report is executed but after queries are parsed.

Between Pages:

      Between Pages Fires before each page of the report is formatted, except the very first page. This trigger can be used for customized page formatting. In the Previewer, this trigger only fires the first time that you goes to a page. If you subsequently return to the page, the trigger does not fire again.

After Report:

      After Report Fires after you exit the Previewer, or after report output is sent to a specified destination, such as a file, a printer, or an Oracle Office userid. This trigger can be used to clean up any initial processing that was done, such as deleting tables. Note, however, that this trigger always fires, whether or not your report completed successfully.

In Oracle Reports what is Flex Mode On/Off?

      On: parent borders "stretch" when child objects are moved against them.

      Off: parent borders remain fixed when child objects are moved against them.

What is the Difference between Repeating Frame and Frame?

      Repeating Frame: The repeating frame is fired once for each record of the group.

      Frame: The frame is fired only once.

                                                                                                                             Previous     Next