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 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 Database Application Components"