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.

You can alter the layout of report data by selecting columns or by applying filters, highlighting, and sorting. You can also define breaks, aggregations, group by, computations, and different charts.

Additionally, you can create multiple variations of a data grid and save them as named reports, for either public or private viewing. You can also use the data from a data report and include it as a chart or report within any page.

Create a data report either by entering the table or view name or by providing a SQL query.

To create a data report:

1. Run the Websheet application.
2. From the Report menu, select New Report.

   Tip:

   You can also select New Report on the Control Panel.

   The Create Report page appears.
3. For Report Source, identify how to develop your source. Options include:
   • Table - Select Table and enter the following:

     • Table or View Name - Select the name of the table or view on which to base the report.

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

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

4. Click Next.
5. Confirm your selections and click Create Report.

View a data report by selecting View All in the Report menu, then edit the report by clicking Edit Attributes.

To view or modify a data report:

1. Run the Websheet application.
2. From the Report menu, select View All.
   The Report page appears.
3. Select the report.
   The report appears.
4. To edit report attributes:
   1. From the Manage menu, click Edit Attributes.
      The Report Attributes page appears.
   2. Edit the attributes and click Apply Changes.
5. To edit the report query:
   1. From the Manage menu, click Edit Query.
      The Report Query page appears.
   2. Edit the report query and click Apply Changes to save your query.

Delete a data report from a Websheet by clicking Delete in the Report Attributes page.

To delete a data report:

1. Run the Websheet application.
2. From the Report menu, select the report.
   The report appears.
3. Select the report.
   The report appears.
4. From the Manage menu, click Edit Attributes.
   The Report Attributes page appears.
5. Click Delete.