Skip Headers
Oracle® Application Express End User's Guide
Release 4.1

Part Number E26811-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

About Adding Data Reports

Data reports are contributor defined queries on tables or views within the underlying Oracle Database.

Tip:

Before you can add a data report, your Websheet application developer must enable the Allow SQL and PL/SQL attribute on the Websheet properties page. By default, this attribute is disabled. To learn more, see "Editing Websheet Application Properties" in Oracle Application Express Application Builder User's Guide.

Topics:

About Data Reports

Data reports, unlike data grids, are query-only and based on existing data from the Oracle Database. You can specify the table or view name and retrieve all columns or write a SQL statement to retrieve the required data.

Users can alter the layout of report data by selecting columns or by applying filters, highlighting, and sorting. Users can also define breaks, aggregations, group by, computations, and different charts. Additionally, users can create multiple variations of a data grid and save them as named reports, for either public or private viewing. In addition to being available under the View menu, data within a data report can be included as a chart or report within any page.

Creating a Data Report

You can create a data report by either simply entering the table or view name, or by providing a SQL query.

To create a data report:

  1. Run the Websheet as described in "Running a Websheet".

  2. From the Create menu, select New Report.

    Tip:

    You can also select New Report on the Control Panel.

    The Edit Section page appears.

  3. For Report Source, identify how to develop your source. Select one of the following:

    1. Table - Select Table and enter the following:

      • Table or View Name - Select the table name the report is to be based on.

      • Report Name - Enter the name of the report.

      • Report Alias - Enter a report alias. A Report alias is used for linking to the Report within page sections. A Report alias must be unique within an application.

    2. SQL Query - Select SQL Query and enter the following:

      • Report Name - Enter the name of the report.

      • Report Alias - Enter a report alias. A Report alias is used for linking to the Report within page sections. A Report alias must be unique within a Websheet.

      • Query - Enter the SQL query that defines your report.

    3. Click Next.

  4. Confirm your selections and click Create Report.

Viewing and Modifying a Data Report

To view or modify a data report:

  1. Run the Websheet as described in "Running a Websheet".

  2. From the View menu, select Reports.

    The Report page appears.

  3. Select the report.

    The report appears.

  4. To edit report attributes:

    • From the Manage menu, click Edit Attributes.

      The Report Attributes page appears.

    • Edit the attributes and click Apply Changes.

  5. To edit report attributes:

    • From the Manage menu, click Edit Query.

      The Report Query page appears.

    • To save your changes, click Apply Changes.

Deleting a Data Report

To delete a data report:

  1. Run the Websheet as described in "Running a Websheet".

  2. From the View menu, select Reports.

    The Report page appears.

  3. Select the report.

    The report appears.

  4. From the Manage menu, click Edit Attributes.

    The Report Attributes page appears.

  5. Click Delete.