3.7 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 Application Express 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 buttons 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 View Icon 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 executing 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 an interactive report by selecting Download from the Actions menu.
• Subscribing to Report Updates by Email
  Subscribe to an interactive report to receive updated versions it.