Creating a Report Using the Create Page Wizard

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

10.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 10-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: "Managing Interactive Grids" "Making an Existing Interactive Grid Editable"
Faceted Search	Creates a faceted search region and report. First, you select a Data Source (Local Database, REST Enabled SQL Service, or Web Source). If you select a REST Enabled SQL Service or Web 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 `VARCHAR2` columns. 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 `VARCHAR2` columns. See Also: "Example Faceted Search" "Managing Faceted Search"
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

10.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 Web 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 Web Source Modules."

To add a report on a new page by running the Create Page Wizard:

On the Workspace home page, click the App Builder icon.
Select the application.
Click Create Page.
For Create a Page:
1. Page Type - Select Component and then Report.
  
  Tip:
  
  Component pages provides page-level functionality and can be added multiple times within a given application such as reports, forms, charts, or calendars. Feature pages provide application-level functionality and can only be added once per application.
2. Select a report type. Options include:
  - Interactive Report
  - Interactive Grid
  - Faceted Search
  - Classic Report
  - Report with Form
  - List View (Optimized for mobile apps)
  - Column Toggle Report (Optimized for mobile apps)
  - Reflow Report (Optimized for mobile apps)
  Tip:
  
  To learn more about each report type, see "Report Options When Running the Create Page Wizard."
3. Click Next.
What displays next changes based on your selection. Follow the on-screen instruction. To learn more about an attribute, see field-level Help.

Tip:

When prompted to select a Data Source, select Local Database, REST Enabled SQL or Web Source.
To view the report, click Save and Run Page.
The rendered page appears.

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