...

...

...

Discoverer Plus - Sorting

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.

• Select a column to sort on.
• Click the Sort icon on the toolbar.

Note: You can also sort a column by selecting Tools—>Sort from the menu bar.

Group Sort Output  

You can apply group sort to a sort column.  For example, if you are have 50 lines of expenditures on an Award, selecting Group Sort will cause the project number to show only on the first of the 50 lines, and subsequent Awards’ expenditures in the same report will also be grouped.

You can group the information according to the values in one or more items.  For example, you can group sort by Award and by Project. 

Page items

Items in the Page Items position must be moved down to the Column Heading position in order to be available in the Sort Table list.

The example below is taken from GA Project Reconciliation Report.  In this case both project number and project name had to be moved to the column heading position before the sort.  That is because the Page Items position is a sort.

Add a new item (column) to the sort table

In this example:

• Page Item Project Number (and project name) have been moved into the column header position.
• Project number has been Added to the sort.
• Project Number has been moved up to the first position in the sort.

The sort table options are as follows:

• Column: Select the name of the item to which the group sort is to be applied.
• Direction: Specify whether to sort the data from high to low or low to high by clicking an arrow in the Direction field.
• Group: Specify the type of break:

• None,
• Group Sort,
• Page Break,
• or Hidden.

• Line: Specify the width of the break line by entering a positive integer in this cell. A higher number results in a thicker line.
• Space: This option indicates the number of rows below the break line before the value in the group sort item changes.

  Effective: 10/25/10

  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.