Drill down report

A drill-down report is actually two or more reports working together. The top-level report launches a secondary report that provides more details about the data in the current record. To add flexibility in the selection of details, you can create a button in the top-level report that executes PL/SQL to call the detail report and provide conditions for its execution. The detail report can provide details for a single record, a group of records, or the report as a whole. A report can include buttons with PL/SQL actions attached to them. For example, you could use the packaged procedure SRW.RUN_REPORT to define an action for a button that calls another report. This second (or detail) report appears in its own, modal Runtime Previewer. There is no limit to the number of levels you can drill down in this way.