8.3 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 available report options when running the Create Page Wizard and using the Universal Theme.
• 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.

8.3.1 Report Options When Running the Create Page Wizard

Learn about available report options when running the Create Page Wizard and using the Universal Theme.

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	To Learn More
Cards	A cards page consists of individual boxes, which resemble index cards, laid out on a page. Each card displays three pieces of information: Card Title, Description Column, and Additional Text Column. First, you select a table or view on which to build the page. Second, you select the Card Title, Description Column, and Additional Text Column.	See: Managing Cards
Faceted Search	Creates a faceted search page which contains a left Search region and a report. You select a table or view on which to build the page. The wizard shows facet selections with options, enabling you to select or deselect the facet columns. When a page is based on local table, then facet recommendations display based on the statistics of the data in the selected table. In all other cases (that is, when the page is not based on local table), only VARCHAR2 columns are displayed for facet selections. You choose if the report is a classic report or a cards report.	See: Managing Faceted Search
Smart Filters	A smart filters page features a single search field at the top of the page with filters that display suggestion chips. While a smart filters page behaves similarly to faceted search, a smart filters page features a more space efficient layout. You select a table or view on which to build the page. When a page is based on local table, then filter recommendations are displayed based on the statistics of the data in the selected table. In all other cases (that is, when the page is not based on local table), only VARCHAR2 columns are displayed for filter selection. Each suggestion chip displays a single count for the specific suggestion values. The suggestion chip count only displays for filters that support counts, such as LOV-based filter types. Users can search or click a suggestion chip to quickly filter the report. You choose if the report is a classic report or a cards report.	See: Managing Smart Filters
Interactive Grid	An interactive grid presents users a set of data in a searchable, customizable report. Functionally, an interactive grid includes most customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse or keyboard. Enabling Include Form Page includes a modal form page. Then, you select the Data Source and the Source Type (that is, Table or SQL Query). If the Data Source contains BLOB columns, then those columns are automatically excluded from the region source since interactive grid regions do not support BLOB columns. If the Data Source is a local table which has foreign keys selected, then for those columns, the column type is set as Select List. If a if matching LOV already exists, a Shared LOV is automatically created or re-used. You determine if the interactive grid is editable by enabling or disabling Editing Enabled. When this option is enabled, then the grid is rendered read-only and separate form page is created to create and edit the data.	See: Managing Interactive Grids
Interactive Report	Creates a page that contains the formatted result of a SQL query. Enabling Include Form Page includes a modal form page. Then, you select the Data Source and the Source Type (that is, Table or SQL Query). If a Data Source contains BLOB columns and if a local table with primary key constraints is selected as the Data Source, then BLOB columns are set as Download BLOB type, with proper BLOB attributes. If the Data Source is a local table, which has foreign keys selected, then for those columns, the column type is set as Plain Text (based on List of Values). If a if matching LOV already exists, a Shared LOV is automatically created or re-used.	See: Managing Interactive Reports
Classic Report	Creates a page that contains the formatted result of a SQL query. You 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. When a Data Source contains BLOB columns and if a local table with primary key constraints is selected as the Data Source, then BLOB columns are set as Download BLOB type, with proper BLOB attributes. When a local table, which has foreign keys is selected as the Data Source, then for those columns, column type is set as Plain Text (based on List of Values). If a if matching LOV already exists, a Shared LOV is automatically created or re-used. Enable Include Form Page to include a form page for creating or updating records. With the exception of sorting and simple filtering, end users cannot customize a classic report.	See: Managing Classic Reports

8.3.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:

1. On the Workspace home page, click the App Builder icon.
2. Select the application.
3. Click Create Page.
   Create a Page appears and features three tabs: Component, Feature, and Legacy Pages.
4. Under Component, select a report type. Options include:
   • Cards
   • Faceted Search
   • Smart Filter
   • Interactive Grid
   • Interactive Report
   • Classic Report

   Tip:

   To learn more about each report type, see Report Options When Running the Create Page Wizard.

5. 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 REST Data Source.

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