8 Developing Reports
In Oracle APEX, 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.
- Understanding Report Page Types
Learn about the available report page types when running the Create Application Wizard and Create Page Wizard. - 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 an orderly layout of information tiles. Developers choose between three layouts: Grid, Float, or Horizontal (Row). - Managing Smart Filters
A smart filters page features a single search field at the top of the page and a search results report (classic report, cards, map, or calendar). While a smart filter behaves similarly to faceted search, it features a more space efficient layout. - Managing Faceted Search
A faceted search page displays and filters data using an intuitive experience users recognize from ecommerce sites (a left Search region and report region). The report region displays search results as cards or a classic report. - Managing Interactive Grids
An interactive grid presents data in a searchable, customizable report. Includes similar customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse or keyboard. - Managing Interactive Reports
An interactive report page features a searchable, easily customizable report. - Managing Classic Reports
A classic report features a simple report page based on the formatted result of a SQL query. - Managing Sorting with Order By Item
Create an inline static LOV by configuring region-level Order By Item attributes. - 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: