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 on a New Page
Use the Create Page Wizard to wide variety of reports including interactive report, interactive grid, classic report, report with form on table, list view, column toggle report, reflow report, and report on web service. - Creating a Classic or Interactive Report on New Page Using Remote Database References
Run the Create Page Wizard to add a new page with a classic or interactive report that uses a remote database reference. - Report Options When Running the Create Page Wizard
Learn about report options when running the Create Page Wizard.
Parent topic: Developing Reports
Creating a Report on a New Page
Use the Create Page Wizard to wide variety of reports including interactive report, interactive grid, classic report, report with form on table, list view, column toggle report, reflow report, and report on web service.
Tip:
This section describes how to create a report by running the Create Page Wizard from the Application home page. You can also run this wizard in Page Designer by clicking the Create menu and selecting Page.
To create a report on a new page:
Parent topic: Creating a Report Using the Create Page Wizard
Creating a Classic or Interactive Report on New Page Using Remote Database References
Run the Create Page Wizard to add a new page with a classic or interactive report that uses a remote database reference.
Tip:
This section describes how to create a report by running the Create Page Wizard from the Application home page. You can also run this wizard in Page Designer by clicking the Create menu and selecting Page.
To add a classic report or interactive report on a new page:
Parent topic: Creating a Report Using the Create Page Wizard
Report Options When Running the Create Page Wizard
Learn about report options when running the Create Page Wizard.
Tip:
Universal Theme - 42 is optimized to work equally well in either a mobile or desktop environment. In previous releases and in earlier themes, the Mobile user interface is based on jQuery Mobile. Oracle recommends migrating existing mobile applications to the Universal Theme as soon as possible.
Available Reports in the Create Page Wizard
The Create Page Wizard supports the following reports when running the Create Page Wizard with the Universal Theme.
Table 9-2 Create Page Wizard — Available Reports
Report Type | Description | To Learn More |
---|---|---|
Interactive Report |
An interactive report is a formatted result of a SQL query. Developers choose a table on which to build a report, or provide a custom SQL SELECT statement. Developers also select the columns to display in the report. If the report is based on table which has a foreign key constraints to another table, the developer can also define Lookup Columns. Use Lookup Columns to replace identifiers with a display column, such as showing the department name instead of the department number. End users can customize the report layout and data displayed by selecting options on the Actions menu. |
|
Interactive Grid |
An interactive grid is a formatted result of a SQL query. Developers choose a table on which to build the report, or provide a custom SQL query. End users can alter the report layout using Column menus and sort options, rearrange columns by dragging and dropping, and change how data displays using options on the Actions menu. Interactive grids can be editable or non-editable. When an interactive grid is editable, end users can edit the underlying data, add rows, and delete rows. To create an editable interactive grid when running the Create Page Wizard, selecting Yes for the Editing Enabled option. |
See "Managing Interactive Grids" or "Making an Existing Interactive Grid Editable" |
Classic Report |
Formatted result of a SQL query. Developers choose a table on which to build a report, or provide a custom SQL SELECT statement. Developers also select the columns to display in the report. If the report is based on table which has a foreign key constraints to another table, the developer can also define Lookup Columns. Use Lookup Columns to replace identifiers with a display column, such as showing the department name instead of the department number. With the exception of sorting and simple filtering, end users cannot customize a classic report. |
|
Report with Form on Table |
Creates an interactive grid report and form based on the table you specify. For the report, you choose a report type (Interactive Report, Interactive Grid, or Classic Report). |
Not applicable. |
List View |
Optimized for mobile applications. Features a responsive design to display data and provide easy navigation on Smartphones. Creates a page that contains the formatted result of a SQL query. You choose a table on which to build the List view and select a database column to be used for the List view entry. |
Not applicable. |
Column Toggle Report |
Optimized for mobile applications. Creates a responsive report designed for mobile applications and Smartphones. By default, column toggle reports are created with all columns set to the same priority. However, the developer can edit the report column attributes and rank columns by importance. Columns with a lesser priority (larger number) are hidden at narrower screen widths. The report includes a Columns button which enables end users to select which columns they want to view. |
Not applicable. |
Reflow Report |
Optimized for mobile applications. Creates a responsive report designed for mobile applications and Smartphones. When there is not enough space available to display the report horizontally, the report responds by collapsing the table columns into a vertical value pairs layout where each column displays on a separate row. |
See "Developing Reports" |
Report on Web Service |
Creates a report on a Web Service result. |
Available Reports for Mobile User Interface Applications
In previous releases, developers selected the Mobile User Interface to optimize applications for mobile environments. The Mobile user interface is based on jQuery Mobile. If your application users an older theme and the Mobile User Interface, the Create Page Wizard supports the following reports.
Table 9-3 Create Page Wizard — Supported Reports for Mobile User Interface Applications
Page Type | Description | To Learn More |
---|---|---|
List View |
Optimized for mobile applications. Features a responsive design to display data and provide easy navigation on Smartphones. Creates a page that contains the formatted result of a SQL query. You choose a table on which to build the List view and select a database column to be used for the List view entry. |
See "Developing Reports" |
Column Toggle Report |
Optimized for mobile applications. Creates a responsive report designed for mobile applications and Smartphones. By default, column toggle reports are created with all columns set to the same priority. However, the developer can edit the report column attributes and rank columns by importance. Columns with a lesser priority displays at narrower widths. The report includes a Columns button which enables end users to select which columns they want to view. |
See "Developing Reports" |
Reflow Report |
Optimized for mobile applications. Creates a responsive report designed for mobile applications and Smartphones. When there is not enough space available to display the report horizontally, the report responds by collapsing the table columns into a vertical value pairs layout where each column displays on a separate row. |
See "Developing Reports" |
Report on Web Service |
Creates a report on a Web Service result. |
Parent topic: Creating a Report Using the Create Page Wizard