Discoverer Plus - Worksheets - Customizing Worksheets
The ISDS System Usability Director is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.
Browse > Workbooks > Open > Run
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,
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,
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.
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
Adding an Item
Select the Edit Worksheet icon
View Selected and Available items in the Results window
From the menu,
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.