8 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.
Tip:
To view examples, install the sample app, Sample Reporting. To learn more, see Sample Apps.
- 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 Smart Filters
A smart filters page features a single search field with filters at the top of the page and a report. Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. - 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 APEX includes declarativeBLOB
support to enable developers to declaratively upload files in forms, and download or display files in reports.
See Also:
"Developing Forms" and "Managing Database Application Components"