10.2 Creating Reports Using a Wizard

Application Builder includes many built-in wizards that enable you to generate reports. This section summarizes report options when 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 jQuery Mobile Smartphone).

Create Application Wizard Report Options
Create Page Wizard Report Options
Create Region Wizard Report Options
Creating a Report Using the Create Application Wizard
Creating a Report Using the Create Page Wizard
Creating a Report in Page Designer Using a Wizard

Tip:

In some wizards you select the table and in others you provide the SQL query. For assistance in writing the SQL query, click the Query Builder button. See "Building SQL Queries with Query Builder" in Oracle Application Express SQL Workshop Guide.

10.2.1 Create Application Wizard Report Options

Table 10-1 describes available report options when using the Create Application Wizard.

Table 10-1 Create Application Wizard - Available Report Types

Page Type	Description	Desktop	jQuery Mobile Smartphone
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. Note: Desktop applications do not support this report format.	Not available	Available
List View	Displays the results of a SQL query in a list for mobile applications. Note: Desktop applications do not support this report format.	Not available	Available
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. Note: Desktop applications do not support this report format.	Not available	Available
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. Note: Desktop applications do not support this report format.	Not available	Available
Rep ort	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. You then choose the report implementation (Interactive or Classic). Note: jQuery Mobile Smartphone only supports classic reports.	Available	Not available
Report a nd Form	You choose a table on which to build a two page report and form combination. You then choose the report implementation (Interactive or Classic). 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.	Available	Not available

10.2.2 Create Page Wizard Report Options

Table 10-2 describes report options when using the Create Page Wizard.

Table 10-2 Create Page Wizard - Available Report Options

Page Type	Description	Desktop	jQuery Mobile Smartphone
Classi c Report	Formatted result of a SQL query. You can 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. For assistance in writing the SQL query, click the Query Builder button. See Also: "Understanding the Difference Between Interactive and Classic Reports" and "Editing Classic Reports in Component View"	Available	Available
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. Note: Desktop applications do not support this report format.	Not available	Available
Inte ractive Report	Formatted result of a SQL query. Creates an interactive report based on a custom SQL SELECT statement you provide. For assistance in writing the SQL query, click the Query Builder button. Interactive reports are only supported on Desktop pages. End users can customize the report layout and data displayed by selecting options on the Actions menu. Note: jQuery Mobile Smartphone does not support interactive reports. See Also:"Understanding the Difference Between Interactive and Classic Reports," "Customizing Interactive Reports as an End User," and "Editing Interactive Reports in Component View"	Available	Not available
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. Note: Desktop applications do not support this report format.	Not available	Available
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. Note: Desktop applications do not support this report format.	Not available	Available
Repor t on Web Service	Creates a report on a Web Service result. See Also: "Implementing Web Services"	Available	Available

10.2.3 Create Region Wizard Report Options

Table 10-3 describes report options when using the Create Region Wizard.

Table 10-3 Create Region Wizard Report Options

Page Type	Description	Desktop	jQuery Mobile Smartphone
In teractive Report	Formatted result of a SQL query. You provide a custom SQL SELECT statement or a PL/SQL function returning a SQL Query statement. Note: jQuery Mobile Smartphone does not support interactive reports. See Also: "Customizing Interactive Reports as an End User," "Editing Interactive Reports in Page Designer," and "Editing Interactive Reports in Component View"	Available	Not available
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. Note: Desktop applications do not support this report format. See Also: "Developing Reports"	Not available	Available
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. Note: Desktop applications do not support this report format.	Not available	Available
Classic Report	Formatted result of a SQL query. You provide a custom SQL SELECT statement or a PL/SQL function returning a SQL Query. See Also: "Editing Classic Reports in Page Designer" and "Editing Classic Reports in Component View"	Available	Not available
ListView	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 provide a custom SQL SELECT statement or a PL/SQL function returning a SQL Query. Note: Desktop applications do not support this report format.	Not available	Available
Report on Web Service	Creates a report on a Web Service result. See Also: "Implementing Web Services"	Available	Available

See Also:

"About Regions"

10.2.4 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 Application Builder icon.
Click the Create button.
For the application type, select Desktop 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 a name to identify the application.
3. Application - Enter a unique integer value to identify the application. Application IDs between 3000 to 9000 are reserved for internal use by Oracle Application Express.
4. User Interface - Select a user interface for the application. For application primarily designed for desktop use, select Desktop.
5. Theme - Select a theme for this application.
  
  Themes are collections of templates that you can use to define the layout and style of an entire application. See "Using Themes."
6. Theme Style - Select a theme style.
  
  Theme styles are only available for newer applications such as Universal Theme - 42 and Mobile - 51. See "Using Theme Styles."
7. Click Next.
Tip:
To create an application at this point that consists of just a login page and blank page, click Create Application.

Next, add pages to your application.
Click the Add Page button. On Add Page:
1. Select Page Type - Select page type. See "Create Application Wizard - Available Report Types."
  
  Tip:
  The Page Type determines if additional attributes display. To learn more about an attribute, see field-level Help. See "Viewing Field-Level Help."
2. Parent Page - If this page is subordinate to another page, select the parent page.
3. Page Name - Specify a name for this page.
4. Click Add Page.
To add more pages, repeat the previous step.
When you are done adding pages, click Next.
Follow the on-screen instructions.

See Also:

"Creating a Database Application"

10.2.5 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 Application Builder icon.
Select the application.
Click Create Page and click Next.
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 and click Next. See "Create Page Wizard - Available Report Options."

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. See "Viewing 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.

10.2.6 Creating a Report in Page Designer Using a Wizard

To add a new report to a page in Page Designer declaratively:

View the page in Page Designer. "Viewing a Page in Page Designer."
Locate the Page Designer Toolbar at the top of the page.
On Page Designer Toolbar, click the Create menu and select Create Report Region.

The Create Region Wizard appears.
Select the type of report you wish to create and click Next. To learn more about report options, see "Create Region Wizard Report Options."
Follow the on-screen instructions.