Discoverer Plus - Worksheets - Customizing Worksheets

...

Distribution

ODS Specialist

ODS Specialist-Limited

ODS Specialist-Restricted

Ownership

The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Discoverer Plus
Browse > Workbooks > Open > Run
Result Window

The Results Window

Worksheet: The results of the query are displayed in this region.

Once you have viewed the results in the results window, you have many options for making changes. Below are summarized some of the short-cuts you may wish to routinely use to take advantage of Discoverer’s many capabilities. Remember there is usually more than one way to do almost everything, and you can use right clicks or the menu.

Block An Entire Worksheet

Use (Control + a) as a quick way to block the entire worksheet.

After you have blocked the worksheet,

Right click anywhere in the blocked area and you will see options available that will apply to the entire worksheet.

(i.e., Format Data allows you to change the color, font size, etc. of all the data for the entire worksheet, rather than formatting one at a time.)

Without blocking the worksheet, there are right clicks that you can use for any column of data. The example (below) shows the choices available if you right click on a single column header. If you right click on a data point, you will see an additional tab [Number] where you can format currency, etc.

Format all Headings

*Note: You must select the first heading before you hold down the Shift key, and don’t release the Shift key until you have selected the last heading to be included.

To Format all headings,

Select the first heading
Hold down the Shift Key
And then select the last heading.
Right click anywhere on the headings or in the blocked body of the report: Format Heading is then available.

Re-arrange Headers using the right click

The example to the right shows you a way to re-arrange headers, by selecting the placement before or after other columns in your query.

You can also re-arrange the Headers (columns) using the Edit Worksheet icon.

Worksheet Description

Right click on the worksheet name tab and select [Worksheet Properties]

You can type a description of the worksheet that you will be able to view prior to running a query.

After you’ve created the Description, view below how this will help you in selecting an appropriate worksheet within a workbook.

Removing an Item

Select the item you want to remove (right click on the heading)

And select [Remove from Worksheet]
Or click on the column heading and select the delete key on the keyboard.

Alternately, you can

select the [Edit Worksheet] icon,
[Select Items] tab.
Drag the item to the Available list (or select and use the left arrow).

Adding an Item

Select the Edit Worksheet icon

To open the wizard, select the Edit Worksheet icon.
Alternatively, from the menu, you can select [Edit], [Worksheet].

View Selected and Available items in the Results window

From the menu,

select [View, Available Items Pane] and/or
[View, Selected Items Pane]
Effective: 6/29/2010

Revision: 1

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.

Oracle® Tutor Copyright © 1997, 2009, Oracle. All rights reserved.