9 Developing Reports
In Oracle Application Express, a report is the formatted result of a SQL query. You can generate the SQL query by selecting a table or view in a wizard, or by defining the SQL query manually.
- Creating a Report Using the Create Application Wizard
Run the Create Application Wizard to create a new application containing one or more pages. Supported report pages include cards, faceted search, interactive grid, interactive report, and classic report.
- Creating a Report Using the Create Page Wizard
Run the Create Page Wizard from an existing application to create a variety of different reports.
- Creating a Report by Dragging and Dropping from the Gallery
Create a report by dragging and dropping a report type from the Gallery.
- Managing Cards
A cards page features colorful blocks, which resemble index cards, laid out on a page.
- Managing Faceted Search
A faceted search page features a faceted search region on the left side of the page and report on the right side of the page.
- Managing Interactive Grids
An interactive grid presents users a set of data in a searchable and customizable report.
- Managing Interactive Reports
An interactive report is the formatted result of a SQL query. End users can customize the report layout and data displayed by selecting options on the Actions menu.
- Managing Classic Reports
A classic report is the formatted result of a SQL query.
- Printing Report Regions
Configure a report region to print by exporting it to several different formats.
- Understanding BLOB Support in Forms and Reports
Oracle Application Express includes declarative
BLOBsupport to enable developers to declaratively upload files in forms, and download or display files in reports.
"Developing Forms" and "Managing Database Application Components"