An interactive report is a formatted result of a SQL query.
About Interactive Reports
In addition to interactive grids, Oracle Application Express includes two main report types: an interactive report and a classic report.
Accessing Interactive Reports
An interactive report is contained in a page within a database application. To access an interactive report you must go to the database application URL, log in using your account credentials (that is, your username and password), and then navigate to the report page.
Using the Search Bar
A search bar displays above interactive reports and includes the following features.
Using the Select Columns To Search Icon
The Select columns to search icon displays to the left of the search bar. Click this icon to display a listing of all columns in the current report.
Using the Column Heading Menu
Clicking a column heading in an interactive report displays the Column Heading menu. Positioning the cursor over each icon displays a tooltip that describes its function.
Using Interactive Report Filters
When you customize an interactive report, a filter displays between the search bar and the report.
