6.10 Adding Data Reports
Data reports are contributor defined queries on tables or views within the underlying Oracle Database.
Important:
Before you can add a data report, your Websheet application developer must enable the Allow SQL attribute on the Websheet properties page. By default, this attribute is disabled.
- 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. - Creating a Data Report
Create a data report either by entering the table or view name or by providing a SQL query. - Viewing and Modifying a Data Report
View a data report by selecting View All in the Report menu, then edit the report by clicking Edit Attributes. - Deleting a Data Report
Delete a data report from a Websheet by clicking Delete in the Report Attributes page.
See Also:
-
"Editing Websheet Application Properties" in Oracle Application Express App Builder User’s Guide
Parent topic: Using Websheets
6.10.1 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.
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.
Parent topic: Adding Data Reports
6.10.2 Creating a Data Report
Create a data report either by entering the table or view name or by providing a SQL query.
To create a data report:
Parent topic: Adding Data Reports
6.10.3 Viewing and Modifying a Data 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:
Parent topic: Adding Data Reports
6.10.4 Deleting a Data Report
Delete a data report from a Websheet by clicking Delete in the Report Attributes page.
To delete a data report:
Parent topic: Adding Data Reports