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). 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: