At the top of each report page is a search region. The region provides the following features:

• Select columns icon allows you to identify which column to search (or all).
• Text area allows for case insensitive search criteria (no need for wild cards).
• Rows selects the number of records to display per page.
• [Go] button executes the search.
• Actions Menu icon displays the actions menu (discussed next).

Please note that all features may not be available for each report.

^ Back to Top

The actions menu is used to customize the display of your Interactive Report.

^ Back to Top

Used to modify the columns displayed. The columns on the right are displayed. The columns on the left are hidden. You can reorder the displayed columns using the arrows on the far right. Computed columns are prefixed with **.

^ Back to Top

Used to add or modify the where clause on the query. You first select a column (it does not need to be one that is displayed), select from a list of standard Oracle operators (=, !=, not in, between), and enter an expression to compare against. The expression is case sensitive and you can use % as a wild card (e.g. STATE_NAME like A%).

^ Back to Top

Used to change the column(s) to sort on and whether to sort ascending or descending. You can also specify how to handle nulls (use the default setting, always display them last or always display them first). The resulting sorting is displayed to the right of column headings in the report.

^ Back to Top

Used to create a break group on one or several columns. This pulls the columns out of the Interactive Report and displays them as a master record.

^ Back to Top

Highlighting allows you to define a filter. The rows that meet the filter are highlighted using the characteristics associated with the filter.

• Name is used only for display.
• Sequence identifies the sequence in which the rules will be evaluated.
• Enabled identifies if the rule is enabled or disabled.
• Highlight Type identifies whether the Row or Cell should be highlighted. If Cell is selected, the column referenced in the Highlight Condition is highlighted.
• Background Color is the new color for the background of the highlighted area.
• Text Color is the new color for the text in the highlighted area.
• Highlight Condition defines your filter condition.

  ^ Back to Top

Computations allow you to add computed columns to your report. These can be mathematical computations (e.g. NBR_HOURS/24) or standard Oracle functions applied to existing columns (some have been displayed for example, others, like TO_DATE, can also be used).

• Computation allows you to select a previously defined computation to edit.
• Column Heading is the column heading for the new column.
• Format Mask is an Oracle format mask to be applied against the column (e.g. S9999).
• Computation is the computation to be performed. Within the computation, columns are referenced using the aliases displayed.

Below computation, the columns in your query are displayed with their associated alias. Clicking on the column name or alias will write them into the Computation. Next to Columns is a Keypad. These are simply shortcuts of commonly used keys. On the far right are Functions. An example computation to display Total Compensation is:

CASE WHEN A = 'SALES' THEN B + C ELSE B END (where A is ORGANIZATION, B is SALARY and C is COMMISSION)

^ Back to Top

Aggregates are mathematical computations performed against a column. Aggregates are displayed after each control break and at the end of the report within the column they are defined

• Aggregation allows you to select a previously defined aggregation to edit.
• Function is the function to be performed (e.g. SUM, MIN).
• Column is used to select the column to apply the mathematical function to. Only numeric columns will be displayed.

^ Back to Top

Performs a flashback query to allow you to view the data as it existed at a previous point in time. The default amount of time that you can flashback is 3 hours (or 180 minutes) but the actual amount will differ per database.

^ Back to Top

Resets the report back to the default settings, removing any customizations that you have made.

^ Back to Top

Allows the current result set to be downloaded. The download formats will differ depending upon your installation and report definition but may include CSV, XLS, PDF, or RTF. Currently, CSV format is the only option available.

^ Back to Top

Clicking on any column heading exposes a column heading menu.

• Sort Ascending icon sorts the report by the column in ascending order.
• Sort Descending icon sorts the report by the column in descending order.
• Hide Column hides the column.
• Break Column creates a break group on the column. This pulls the column out of the report as a master record.
• Column Information displays help text about the column, if available.
• Text Area is used to enter case insensitive search criteria (no need for wild cards). Entering a value will reduce the list of values at the bottom of the menu. You can then select a value from the bottom and the selected value will be created as a filter using '=' (e.g. column = 'ABC'). Alternatively, you can click the flashlight icon and the entered value will be created as a filter with the 'LIKE' modifier (e.g. column LIKE '%ABC%').
• List of Unique Values contains the first 500 unique values that meet your filters. If the column is a date, a list of date ranges is displayed instead. If you select a value, a filter will be created using '=' (e.g. column = 'ABC').

^ Back to Top

To view the details of a single row at a time, click the single row view icon on the row you wish to view. If available, the single row view will always be the first column. Depending on the customization of the Interactive Report, the single row view may be the standard view or a custom page that may allow update.

^ Back to Top

If you have customized your Interactive Report, the report settings will be displayed below the Search Bar and above the report. If you have saved customized reports (this feature is currently not available), they will be shown as tabs. You can access your alternate views by clicking the tabs. Below the tabs are the report settings for the current report. This area can be collapsed and expanded using the icon on the left.

For each report setting, you can:

• Edit by clicking the name.
• Disable/Enable by unchecking or checking the Enable/Disable checkbox. This is used to temporarily turn off and on the setting.
• Remove by click the Remove icon. This permanently removes the setting.

If you have created a chart, you can toggle between the report and chart using the Report View and Chart View links shown on the right. If you are viewing the chart, you can also use the Edit Chart link to edit the chart settings. Currently, the Chart View and Edit Chart links are not available.

^ Back to Top