Progress
Report Builder
User’s Guide


Changing the Group Order

Once you have specified multiple group fields, you can change the group order by:

Report Builder automatically readjusts the group level numbers.

Modifying Group Levels

When you modify a group level, you can change the group field or any of the grouping options.

Follow these steps to modify a group level:

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

If you want to change the group level, use the Move Up or Move Down button in the Group Order dialog box.

Inserting Group Levels

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

Follow these steps to insert an additional group level:

  1. Choose Database Group Order. The Group Order dialog box appears.
  2. Choose New. The Group Level dialog box appears.
  3. Select a group level number.
  4. Select the group field.
  5. Specify any grouping options.
  6. Choose OK. Report Builder returns to the Group Order dialog box, inserts the new group level at the specified level number, and moves the current level and those below it down one level.
  7. Choose OK to return to the report layout.

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

Deleting Group Levels

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

Follow these steps to delete a group level:

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

You can move group levels up or down within the group order list. When you move a group level, Report Builder automatically renumbers the group levels.

Follow these steps to move a group level:

  1. Choose Database Group Order. The Group Order dialog box appears.
  2. Select the group level you want to move (or renumber).
  3. Choose Move Up or Move Down. Report Builder moves the selected group level one level in the appropriate direction and renumbers all the affected group levels.
  4. Repeat Step 3 until the group 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 group level, Item-Num is the second group level, and Cust-Num is the third group level. To move Cust-Num to be the first level, select 3) Custumer.Cust-Num, then choose Move Up twice. Report Builder moves Cust-Num to the first group level and renumbers Order-Num and Item-Num.


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