By default, an interactive report includes a search bar, an Actions menu, a Column Heading menu, and Edit icons in the first column of each row. Users can use these controls to alter the layout of report data by selecting columns, applying filters, highlighting, and sorting. Developers can customize an interactive report in Component View and configure how these controls display.
Topics:
Developers can customize an interactive report by editing report attributes.
Topics:
To access the Report Attributes page:
The Report Attribute page is divided into these sections. You can access these sections by scrolling down the page, or by clicking a navigation button at the top of the page. When you select a button at the top of the page, the selected section appears and all other sections are temporarily hidden. To view all sections of the page, click Show All.
You can use the Column Attributes section of the Report Attributes page to precisely control the report layout. For example, you can use these attributes to alter column heading text, change column positioning, or hide a column.
To access Column Attributes:
Use column groups to group columns on a single row view.
To create a column group:
Access the Interactive Report Attributes page. See "Accessing the Interactive Report Attributes Page in Component View."
The Interactive Report Attributes page appears.
Scroll down to Column Groups.
Click Add Group.
Under Column Group:
Sequence - Enter the display sequence for this column group. This attribute determines the order in which the column groups display in the detail view.
Group Name - Enter a column group name. This name displays in the region header in detailed view.
Description - Enter an optional description for the column group. This description never displays to the end user.
Click Create.
You control how pagination displays by making selections from Pagination attributes on the Interactive Report Attributes page.
To access the Pagination section of the Report Attributes page:
Developers can customize if and how the search bar and Actions menu display.
Topics:
See Also:
"Enabling Icon View in Component View" and "Enabling Detail View in Component View"
A search bar displays at the top of every interactive report and includes a Select columns to search icon, Text area, Go button, and Actions menu.
If users have saved multiple reports, a saved report select list displays to the right of the Go button. Users can use this list to select a specific saved report. If multiple views are configured, a view selection button group also displays which enables the end user to switch views. Developers can remove or customize the search bar by selecting and deselecting options in the Search Bar section of the Interactive Reports Attributes page.
The Download option to the Actions menu to enables users to download an interactive report as a comma-delimited file (CSV) format, HTML, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), Microsoft Word Rich Text Format (RTF), or as HTML attached to an email.
WARNING:
There is a 32K limit on downloads from the reports to advanced formats, such as PDF, XLS, and Word. If the end user has too many columns displayed then they may encounter an error when attempting to download the data to these advanced formats. Downloads may also take considerable time to complete for large data sets.
Note:
The Group By and Pivot view do not support download formats of XLS, PDF, RTF even if they are enabled and report server is configured.
To configure download formats:
Access the Interactive Report Attributes page. See "Accessing the Interactive Report Attributes Page in Component View."
The Interactive Report Attributes page appears.
Scroll down to Search Bar.
For Include Search Bar, select Yes and then select Actions Menu.
Under Include in Actions menu, select Download.
Tip:
Disabling the Download functionality only prevents the Download menu from displaying on the Actions menu. To fully prevent users from downloading data, deselect all check boxes in the Download Formats section.
Scroll down to Download.
Select download formats. Options include:
CSV. See "Enabling CSV Download."
HTML.
Email. See "Enabling Email Download."
XLS.
PDF. See "About Printing Reports to PDF."
RTF.
Tip:
The Download option only appears on the Actions menu if a file format is selected. If a report server has not been defined within Instance Administration then certain options do not display. To learn more, see "Configuring Report Printing" Oracle Application Express Administration Guide.
Click Apply Changes.
To enable the Enable CSV download:
Enable the CSV output option on the Edit Globalization Attributes page. See "Accessing the Globalization Attributes Page" and "Automatic CSV Encoding."
Access the Interactive Report Attributes page. See "Accessing the Interactive Report Attributes Page in Component View."
The Interactive Report Attributes page appears.
Scroll down to Search Bar.
For Include Search Bar, select Yes and then select Actions Menu.
Under Include in Actions menu, select Download.
Scroll down to Download.
From Download Formats, select CSV.
Tip:
The Download option only appears on the Actions menu if a file format is selected.
In the CSV Separator, define the column separator. If no value is entered, a comma or semicolon is used depending on your current NLS settings.
In the CSV Enclosed By, enter a delimiter character. This character delineates the starting and ending boundary of a data value. Default delimiter is double quotation marks (" ").
In Filename, enter a name for the downloaded document. Do not specify a file extension, the extension is added automatically. If you leave this blank, the region name is used as the file name.
Click Apply Changes.
You can configure the Download option to send static HTML report to specific email addresses.
Tip:
Email download is only supported on authenticated pages. If you enable Email download on a public page, the Email download option does not display in Download dialog.
To enable email download:
An Oracle Application Express administrator must configure email at the Instance level. See "Configuring Mail" in Oracle Application Express Administration Guide
Access the Interactive Report Attributes page. See "Accessing the Interactive Report Attributes Page in Component View."
The Interactive Report Attributes page appears.
Scroll down to Search Bar.
For Include Search Bar, select Yes and then select Actions Menu.
Under Include in Actions menu, select Download.
Scroll down to Download.
From Download Formats, select Email.
Tip:
The Download option only appears on the Actions menu if a file format is selected.
Click Apply Changes.
Note:
Email sent from an Email Download contains a system generated email signature identifying who sent the email. This signature cannot be removed.
See Also:
A Link Column displays on the left side of an interactive report. This section describes how to configure a Link Column to link to a single row view, a custom target, or be excluded from the report.
Tip:
A Link Column cannot be sorted, hidden, or moved by an end user and does not interact with the standard column link defined on the Column Attributes page.
Topics:
To link to a single row view:
Tip:
If an interactive report links to single row view and the link icon is missing ALT
text or has empty ALT
text, the alt="Single Row View"
gets included automatically to improve accessibility. This can be further improved by making the ALT
text something specific to the row, for example alt="View Row: #COLUMN_NAME#"
(where COLUMN_NAME
should be a column that helps uniquely identify the current row).
Use Column Attributes to create a link from a report to another page in your application or to a URL.
To create a column link to another page:
Access the Interactive Report Attributes page. See "Accessing the Interactive Report Attributes Page in Component View."
The Interactive Report Attributes page appears.
Under Column Attributes, locate the column to contain the link.
Click the Edit icon next to the column name.
The Column Attributes page appears.
Scroll down to Column Link.
To create a column link to another page:
From Target, select Page in this Application.
(Optional) In Link Attributes, specify additional column link attributes to be included in the <a href= >
tag (for example, a link target, classes, or styles).
In Link Text, enter the text to be displayed as a link, specify an image tag, or pick from the list of default images.
In Page, specify the target page number. To reset the pagination for this page, select Reset Pagination.
In Request, specify the request to be used.
In Clear Cache, specify the pages (that is, the page numbers) on which to clear cache. You can specify multiple pages by listing the page numbers in a comma-delimited list.
Use the Name and Value fields to specify session state for a specific item.
For Checksum - Select one of the following:
Use default
Application Level - Link reusable by any user
User Level - Link reusable by current user
To learn more, see field-level Help.
Click Apply Changes.
To create a column link to a URL:
Access the Interactive Report Attributes page. See "Accessing the Interactive Report Attributes Page in Component View."
The Interactive Report Attributes page appears.
Access the Column Attributes page by clicking the Edit icon next to the appropriate column.
The Column Attributes page appears.
Scroll down to Column Link.
Under Column Link, specify the following:
From Target, select URL.
In Link Text, enter the text to be displayed as a link and select a substitution string.
(Optional) In Link Attributes, specify additional column link attributes to be included in the <a href= >
tag (for example, a link target, classes, or styles).
In URL, enter the appropriate address.
Click Apply Changes.
You can choose to have interactive reports display conditionally by editing region attributes on the Edit Region page.
To display an interactive report conditionally:
Tip:
Asynchronous JavaScript and XML (Ajax) is used throughout interactive reports. Because Ajax is asynchronous, the value evaluated for conditional display must be in the session. To display an interactive report conditionally based on specified value, use a page item instead of using a :REQUEST
value. Using :REQUEST
in a conditional display causes an interactive report to function incorrectly.
In interactive reports you can use a list of values to improve the speed of built-in filter tools.
To define a report column as a list of values:
You can use HTML expressions in interactive reports to further the customize column display.
To define column formatting:
Be default, most interactive reports display as a report. You can optionally display columns as icons. When configured to display columns as icons, a View Icons icon displays on the Search bar.
To use Icon view, you must identify the columns used to identify the icon, the label, and the target (that is, the link). As a best practice, set these columns to display as hidden since they are typically not useful for end users.
Be default, most interactive reports display as a report. You can optionally display details about each column. When configured, a View Details icon displays on the Search bar.
To add Details view to an interactive report:
This section describes how to configure Advanced Attributes section of the Interactive Report Attributes page to define the Interactive Report region alias, specify an item whose value stores the saved report ID, and define a from address in an interactive report subscription or email download.
You can define the from address for emails sent from an interactive report in two ways:
At the application-level on the Edit Application Definition page in the Application Email from Address attribute. See "Edit Application Definition Page."
At the interactive report-level on the Interactive Report Attributes page in the Email from Address attribute. See "Configuring Interactive Report Advanced Attributes."
In either case, the value can be a literal string containing a valid email or an application substitution defined at the application-level using substitution syntax or &APP_EMAIL. substitution which returns the Application Email From Address defined at the application-level. Examples:
john.doe@abc.com &MY_APP_EMAIL_FROM. &APP_EMAIL.
Oracle does not recommend using an item substitution at the application or page-level since it only works in email download, but not for subscriptions.
See Also:
"Enabling Email Download" and Understanding Substitution Strings
This section describes how developers can view and manage default interactive reports.
Topics:
See Also:
"Saving a Default Interactive Report" and "Managing Saved Interactive Reports" in Oracle Application Express Administration Guide
Developers can edit the report alias or view link examples for default reports on the Saved Reports page.
To edit the report alias for a default report.
Developers can view saved report activity by clicking the View Saved Report Activity link under Tasks on the Edit Report Attributes page. This link only displays if saved reports other than the primary default report exist. You can use this page to determine which reports are being used and which ones are not.
To view saved report activity:
Tip:
You can also view saved report activity from the Workspace Administration page. On the Workspace home page, click the Administration menu and then select Administration, Monitory Activity and By Interactive Report.