8.2.1 Creating Reports Using a Wizard

App Builder includes many built-in wizards that enable you to generate reports. Developers can create reports using the Create Application Wizard, Create Page Wizard, and Create Region Wizard. Note that the available report options differ depending the selected user interface (for example, Desktop and Mobile).

Topics:

8.2.1.1 Report Options When Running the Create Application Wizard

When you run the Create Application Wizard, you choose a target user interface. The user interface you select determines the available page types and report options.

Available Reports for Desktop Applications

If you are creating a desktop application, the Create Application Wizard supports the following report types.

Table 8-1 Create Application Wizard - Available Reports for Desktop Applications

Report Type	Description
Report	Creates a page that contains the formatted result of a SQL query. Developers choose a table on which to build a report, or provide a custom SQL SELECT statement. Once developer select a page source (that is Table or SQL Query) they choose a Report Type (interactive report, interactive grid, or classic report).
Report and Form	Choose a table on which to build a two page report and form combination. You then choose the report type (interactive report, interactive grid, or classic report). On the first page, users select a row to update. On the second page, users can add a record, or update or delete an existing record.
Editable Interactive Grid	An interactive grid presents users a set of data in a searchable, customizable report. In an editable interactive grid, users can also add to, modify, and refresh the data set directly on the page. 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. You choose a table on which to build the interactive grid.

Available Reports for Mobile Applications

If you are creating a mobile application, the Create Application Wizard supports the following report types.

Table 8-2 Create Application Wizard - Available Report Types for Mobile Applications

Page Type	Description
List View	Creates a responsive report for mobile applications. The report works by collapsing the table columns into a stacked presentation that looks like blocks of label and data pairs for each row. This switch occurs when there is not enough space available to display the report horizontally.
Column Toggle Report	Creates a responsive report for mobile applications. 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 display at narrower widths (for example, columns with priority 6 will be hidden first and columns with priority 1 will be hidden last.) The report includes a Columns button which enables end users to select which columns they want to view.
Reflow Report	Creates a responsive report for mobile applications. When there is not enough space available to display the report horizontally, the report works by collapsing the table columns into a stacked presentation that looks like blocks of label and data pairs for each row.
List View	Displays the results of a SQL query in a list for mobile applications.
List View and Form	Optimized to display data and provide easy navigation on Smartphones. Builds a two page List view and form combination. On the first page, users select a row to update from the List View. On the second page, users can update the selected table or view.

8.2.1.2 Report Options When Running the Create Page Wizard

When you create an application, you choose a target user interface. The user interface you select determines the available report types.

Available Reports for Desktop Applications

If you are creating a desktop application, the Create Page Wizard supports the following reports.

Table 8-3 Create Page Wizard — Reports for Desktop Applications

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. End users can customize the report layout and data displayed by selecting options on the Actions menu.	See "Managing Interactive Reports"
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 SELECT statement. 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. 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. With the exception of sorting and simple filtering, end users cannot customize a classic report.	See Managing Classic Reports
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.
Report on Web Service	Creates a report on a Web Service result.	"See Implementing Web Services"

Available Reports for Mobile Applications

If you are creating a mobile application, the Create Page Wizard supports the following reports.

Table 8-4 Create Page Wizard — Supported Reports for Mobile Applications

Page Type	Description	To Learn More
List View	List View is optimized 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	Creates a responsive report for mobile applications. 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	Creates a responsive report for mobile applications. When there is not enough space available to display the report horizontally, the report works by collapsing the table columns into a stacked presentation that looks like blocks of label and data pairs for each row.	See "Developing Reports"
Report on Web Service	Creates a report on a Web Service result.	See "Implementing Web Services"

8.2.1.3 Creating a Report Using the Create Application Wizard

By running the Create Application Wizard, you can create a new application that contains one or multiple report pages.

To create a report using the Create Application Wizard:

On the Workspace home page, click the App Builder icon.
Click the Create button.
Select the application type and click Next.
For Name:
1. Schema - Each application obtains its privileges by parsing all SQL as a specific database schema. Identify the database schema owner.
2. Name - Enter the name used to identify the application to developers.
3. Application - Specify an integer value that identifies the application. The application ID must be unique within your Application Express instance. Application IDs between 3000 to 9000 are reserved for internal use by Oracle Application Express.
4. Theme - Select a theme. Themes are collections of templates used to define the layout and style of an entire application.
  
  To view available themes, click Select Theme. Standard themes display. To view additional themes, make a selection from the Show list. When you select a theme the application automatically subscribes to it.
5. Theme Style - Select a theme style. Theme styles are only available for newer applications such as theme 42 and 51.
6. Click Next.
Tip:

To create an instant application that includes just a login page and blank page, click the Create Application button.

Next, add pages to your application.
For Pages, click Add Page.
1. Select Page Type - Select the type of page you want to add. See "Report Options When Running the Create Application Wizard."
  
  Based on the Page Type, the wizard prompts you for different information, such as selecting a table name or report implementation. To learn more, see field-level Help.Action displays the currently selected page type. For each selection, the wizard prompts you for different types of information, such as selecting a table name or report implementation. To learn more, see field-level Help.
2. Click Add Page.
  
  The page (or pages) appear at the top of the page. To delete a page, click the Delete icon (the X in the far right column).
3. Repeat the previous steps until all pages have been added.
  
  Tip:
  
  To exit the wizard early and use App Builder Defaults, click the Create Application button.
4. Click Next
When you are done adding pages, click Next.
Follow the on-screen instructions.

8.2.1.4 Creating a Report Using the Create Page Wizard

By running the Create Page Wizard, you can add a new page containing a report to an existing application.

To create a report using 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. User Interface - Select a user interface for the page.
2. Select a page type - Select Report.
3. Click Next.
Select a report type. See "Report Options When Running the Create Page Wizard."

The report options that display depend upon the application user interface (for example, Desktop or jQuery Mobile Smartphone).
Click Next.
Follow the on-screen instructions.

To learn more about an attribute, see field-level Help.

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 and Component View by clicking the Create menu and selecting Page.