Skip Headers
Oracle® Application Express Application Builder User's Guide
Release 4.2

E35125-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
PDF · Mobi · ePub

9.2 Creating a Report Using a Wizard

Application Builder includes many built-in wizards for generating reports.

To create a report using a wizard:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click Create Page and click Next.

  4. Select Report and click Next.

  5. Select a report type and click Next. Options include:

    • Interactive Report - 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 and you may only define one interactive report per page. End users can customize the report layout and data displayed by selecting options on the Actions menu. See "Customizing Interactive Reports" and "Editing Interactive Reports as a Developer".

    • Classic Report - Creates a report based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide. For assistance in writing the SQL query, click the Query Builder button. See "Editing Classic Reports".

    • Report on Web Service Result - Creates a report based on a Web service result. See "Implementing Web Services".

    • Wizard Report - Creates a classic report without requiring any SQL knowledge. Select the appropriate schema, table, columns, and result set display.

  6. Follow the on-screen instructions. To learn more about a specific field, click the item label.

    When Help is available, the cursor changes to an arrow and question mark. See "About Field-Level Help".