Progress
Report Builder
User’s Guide


Changing the Sort Order

Once you have specified multiple sort levels, you can change the sort order by:

Report Builder automatically readjusts the sort field selections.

Editing a Sort Level

When you modify a sort level, you can change the sort field, the ascending order or the descending order.

Follow these steps to modify a sort level:

  1. Choose Database Sort Order or the Sort button. The Sort Order dialog box appears.
  2. Select the sort level you want to edit.
  3. Choose Edit. The Sort Level dialog box appears.
  4. Modify the sort level in the same manner in which you specified it.
  5. Choose OK to return to the Sort Order dialog box.
  6. Choose OK to save your changes and return to the report layout.

If you want to change the sort level, use the Move Up or Move Down button in the Sort Order dialog box. See the "Moving Sort Levels Up or Down" section later in this chapter.

Inserting Sort Levels

To insert a sort level into the currently defined sort levels, you do not have to renumber each of the existing levels. You simply create a new sort level with the appropriate sort level number.

Follow these steps to insert an additional sort level:

  1. Choose Database Sort Order. The Sort Order dialog box appears.
  2. Choose New. The Sort Level dialog box appears.
  3. Select the desired sort level number.
  4. Select the sort field.
  5. Specify whether the data should appear in ascending or descending order.
  6. Choose OK. Report Builder returns to the Sort Order dialog box, inserts the new sort level at the specified level number, and moves any existing sort information at that level and those below it down one level.
  7. Choose OK to return to the report layout.

For example, Order-Num is the first sort level and Item-Num is the second sort level. To insert Cust-Num as the new first level sort, create a new sort level defining Cust-Num as the sort field and specifying 1 as the sort level number. When you choose OK, Report Builder inserts Cust-Num as the first sort level and reassigns Order-Num to level 2 and Item-Num to level 3.

Deleting Sort Levels

When you delete a sort level, Report Builder automatically reassigns any lower sort level numbers to fill in the deleted level.

Follow these steps to delete a sort level:

  1. Choose Database Sort Order. The Sort Order dialog box appears.
  2. Select the sort level you want to delete.
  3. Choose Delete. Report Builder deletes the selected sort level and moves the levels below it up one level.
  4. Choose OK to save your changes and return to the report layout.
Moving Sort Levels Up or Down

You can move sort levels up or down within the sort order list. When you move a sort level, Report Builder automatically renumbers the sort levels. Follow these steps to move a sort level:

  1. Choose Database Sort Order. The Sort Order dialog box appears.
  2. Select the sort level you want to move.
  3. Choose Move Up or Move Down. Report Builder moves the selected sort level one level in the appropriate direction and renumbers all the affected sort levels.
  4. Repeat Step 3 until the sort level is in the desired placement.
  5. Choose OK to save your changes and return to the report layout.

For example, Order-Num is the first sort level, Item-Num is the second sort level, and Cust-Num is the third sort level. To move Cust-Num to be the first level, select 3) Customer.Cust-Num, then choose Move Up twice. Report Builder moves Cust-Num to the first sort level and renumbers Order-Num and Item-Num.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095