Sample Reporting
Help
APEX_PUBLIC_USER
Sign Out
Sample Reports
Interactive Grid
Interactive Report
Classic Report
Sidebar Filter
Use Cases
Drill Down Report
Report Highlighting
Interactive Report Query API
Linking to Interactive Reports
Bind Variables
Filtering
Non-Tabular Templates
Column Format Masks
Custom Buttons
Reporting from Collections
SQL Examples
CASE Statements
Connect By
Pivot
Regular Expressions
Soundex
String Functions
Group By
Inline Views
Pipelined Functions
Analytic Functions
LEAD and LAG
LISTAGG
RANK and DENSE_RANK
RATIO_TO_REPORT
ROW_NUMBER
Top N Queries
Administration
Use Cases
Breadcrumb
Report Use Cases
Drill Down Report
Includes drill down links from one interactive report to another.
Report Highlighting
Shows how to use the built in row and column highlighting capabilities of Interactive Reports.
Interactive Report Query API
This example shows how to call an Oracle Application Express (APEX) runtime API to get the SQL statement that corresponds to the current user's interactive report filters and use this to drive a chart on another page.
Linking to Interactive Reports
Shows how to link to an interactive report, including syntax to clear settings, reset settings, call named reports, pass filters, etc.
Bind Variables
Shows how to filter an interactive report using a bind variable which derives its value from an Oracle Application Express (APEX) page item.
Filtering
Filter classic report results using a left hand side-bar control region. Uses bind variable references to properly constrain the report.
Non-Tabular Templates
Classic reports are template based, Interactive Reports are not. This example demonstrates the use of a classic report template.
Column Format Masks
See various formatting options for dates, numbers, and percent bar charts which are available from within classic and interactive reports. This example uses an interactive report but the format masks are common between interactive reports and classic reports.
Custom Buttons
An example of how to turn report cells into buttons via CSS. This example uses an interactive report.
Reporting from Oracle APEX Collections
Demonstrates the technique of building reports based upon Oracle APEX collections. This allows for result sets to be manipulated and cached before being reporting on.