Forms and Reports—Advanced - Beginning Oracle Application Express 4.2 - page 159

Figure 7-15. Interactive report for tickets analysis
The interactive report has a built-in Search Bar, which is command central for the interactive report. All of the
end-user features are accessed through the Search Bar. The Search Bar is located on the top of the interactive report,
in the standard location for a report search field. But this is so much more than just a search field! The Search Bar
includes the following:
• Finder drop-down : Represented by the magnifying glass, this feature allows the user to select
which column to filter on.
• Search field : A search field where the user can enter and find text strings.
• Report select list : A select list of all saved reports. This select list is visible only when more than
one saved report is available. We talk about saved reports in a moment.
• Rows-per-page selector : A select list of number-of-rows options. This function is turned off by
default, because it's also available from within the Actions menu.
• Actions menu : A menu of actions enabled for this report—the “interactive” options of the
interactive report.
To use the search field, type a string or phrase into it, and click the Go button. The interactive report lists only
results that match values you entered in the search field.
To use the Finder drop-down, click the arrow at the bottom-right of the magnifying glass icon to the left of the
Search Bar. This action opens a menu of the report column names. Selecting a column name causes the search to be
on the selected column only.
To use the Report select list, select one of the Report List options to navigate to the selected report. To use the
rows-per-page selector, select the desired number of rows per page to display from the select list.
To use the Actions menu, click it to expand the menu of interactive reports actions, and then select the
desired action.