Developing Reports

9 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.

Understanding Report Types
When creating a database application, developers can create four basic report types: interactive grid, interactive report, classic report, or a report with form.
Creating a Report Using the Create Application Wizard
Run the Create Application Wizard to create a new application containing one or more pages. Supported reports include interactive report, classic report, and interactive grid.
Creating a Report Using the Create Page Wizard
Run the Create Page Wizard from an existing application to create a variety of different reports. Supported reports include interactive report, interactive grid, classic report, report with form on table, list view, column toggle report, reflow report, or report on a web service.
Creating a Report by Dragging and Dropping from the Gallery
Create a report by dragging and dropping a report type from the Gallery.
Managing Interactive Grids
An interactive grid presents users a set of data in a searchable and customizable report. Developers control how an interactive grid works by editing the following attributes in Page Designer: region attributes, report Attributes, and Column attributes.
Managing Interactive Reports
An interactive report is the formatted result of a SQL query that is only supported on Desktop pages. End users can customize the report layout and data displayed by selecting options on the Actions menu. Developers control how a interactive report works by editing the following attributes in Page Designer: region attributes, report Attributes, and Column attributes.
Managing Classic Reports
A classic report is the formatted result of a SQL query. Developers choose a table on which to build a report, or provide a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement. Developers control how a classic report works by editing the following attributes in Page Designer: region attributes, report Attributes, and Column 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 Application Express includes declarative BLOB support to enable developers to declaratively upload files in forms, and download or display files in reports.