3.6 Customizing an Interactive Report Using the Actions Menu
Customize an interactive report by selecting options on the Actions menu.
Tip:
Not all options described in this section are available on every Actions menu. Developers can customize what options appear. To learn more, see Customizing the Interactive Report Search Bar in Oracle APEX App Builder User’s Guide.
- About the Actions Menu
The Actions menu appears to the right of the Go button on the Search bar. Use this menu to customize an interactive report. - Selecting Columns to Display
Customize a report to include specific columns. - Adding a Filter
Create row and column filters on an interactive report. - Selecting Column Sort Order
You can specify column display sort order (ascending or descending) by selecting Sort on the Data submenu. - Creating a Control Break
You can create a break group of one or several columns by selecting Actions, Format, and Control Break. - Adding Highlighting
Customize the display to highlight specific rows in a report by selecting Highlight on the Actions, Format submenu. - Computing Columns
Add mathematical computations (for example,NBR_HOURS/24
) or standard Oracle functions to columns. - Defining an Aggregation Against a Column
Define an aggregation against a column with the Actions, Data submenu. Aggregates are displayed after each control break and at the end of the report within the column for which they are defined. - Creating a Chart from the Actions Menu
Create charts in an interactive report with the Actions menu. You can create one chart for each interactive report. Once defined, you can switch between the chart and report views using icons on the Search bar. - Grouping Columns
Group sets of results by one or more columns with Group By, then perform mathematical computations against the columns. Once you define the Group By, switch between the Group By and Report views using the icons on the Search bar. - Managing Pivot Reports
Pivot reports transpose rows into columns to generate results in a crosstab format. - Executing a Flashback Query
View the data as it existed at a previous point in time by running a flashback query on the Actions, Data submenu. - Saving an Interactive Report
Save a private or public interactive report. Only the user who creates a private report can view, save, rename, or delete that private report. - Resetting a Report
Reset a report back to the default settings by selecting Reset from the Actions, Report submenu. Resetting a report removes any customizations you have made. - Downloading a Report
Download or email an interactive report as a CSV, HTML, Excel, or PDF file by selecting Download in the Actions menu. - Subscribing to Report Updates by Email
Subscribe to an interactive report to receive emails when the report is updated.
Parent topic: Using Interactive Reports