Previous Next JavaScript must be enabled to correctly display this content

## 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 declarative `BLOB` support to enable developers to declaratively upload files in forms, and download or display files in reports.

See Also:

Developing Forms and Managing Application Components