8.2 Creating a Report Using the Create Page Wizard
Run the Create Page Wizard from an existing application to create a variety of different reports.
- Report Options When Running the Create Page Wizard
Learn about report options when running the Create Page Wizard. - Creating a Report on New Page
Use the Create Page Wizard to create a wide variety of reports on a local database or on an external data source.
Parent topic: Developing Reports
8.2.1 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 8-2 Create Page Wizard — Available Reports
Report Type | Description |
---|---|
Interactive Report |
Creates an interactive report based on the data source (local or external) you specify. 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. See Also: "Managing Interactive Reports" |
Interactive Grid |
Creates an interactive grid on the data source (local or external) you specify. 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. In an editable interactive grid, end users can edit the underlying data, add rows, and delete rows. To create an editable interactive grid when running the Create Page Wizard, enable the Editing Enabled option. See Also: |
Faceted Search |
Creates a faceted search region and report. First, you select a Data Source (Local Database, REST Enabled SQL Service, or REST Data Source). If you select a REST
Enabled SQL Service or REST
Data Source, facets are not
auto-discovered. Developers can create the faceted
report page, but the facets region will only
contain a search field which searches the
Second, you select the Source Type on which to build the search region and report (Table or SQL Query. If you select a
Table, facets are auto
discovered using APEX Data Dictionary Cache. If
you select a SQL Query,
facets are not auto-discovered. Developers can
create the faceted report page, but the facets
region will only contain a search field which
searches the See Also: |
Classic Report |
Creates a classic report on the data source (local or external) you specify. 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. See Also: Managing Classic Reports |
Report with Form |
Creates a report and form based on the data source (local or external) you specify. For the report, you choose a report type (Interactive Report, Interactive Grid, or Classic Report). |
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 based on the data source (local or external) you specify. List view regions can be based on table or a SQL query you provide. You choose a table on which to build the List view and select a database column to be used for the List view entry. |
Column Toggle Report |
Optimized for mobile applications. Creates a responsive report designed for mobile applications and Smartphones. Creates a page that contains the formatted result of a SQL query based on the data source (local or external) you specify. Column Toggle regions can be based on table or a SQL query you provide. 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. |
Reflow Report |
Optimized for mobile applications. Creates a responsive report designed for mobile applications and Smartphones. Creates a page that contains the formatted result of a SQL query based on the data source (local or external) you specify. Reflow Report regions can be based on table or a SQL query you provide. 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. |
Parent topic: Creating a Report Using the Create Page Wizard
8.2.2 Creating a Report on New Page
Use the Create Page Wizard to create a wide variety of reports on a local database or on an external data source.
The component(s) described in this topic include built-in support for REST Enabled SQL and REST Data Sources which enables read and write access to remote data sources. In order to build a component on a remote data source, you must first create the application and configure the external data source.
Tip:
To learn more about external data sources, see "Managing REST Enabled SQL References" and "Managing REST Data Sources."
To add a report on a new page by running the Create Page Wizard:
Tip:
You can also run the Create Page Wizard in Page Designer by clicking the Create menu and selecting Page.
Parent topic: Creating a Report Using the Create Page Wizard