Progress
Report Builder
Tutorial


Accessing and Ordering Data

Because the Customer table contains all the address information you need for the mailing labels, you do not have to access any other tables. However, you do want to specify the order in which the data appears in the report. Instead of printing the labels in the order in which Report Builder reads them from the database, you can specify to print the mailing labels in alphabetical order by the state in which the customer resides.

Follow these steps to change the sort order:

  1. Choose Database Sort Order or the Sort button. The Sort Order dialog box appears.
  2. Choose the New button to specify a new sort order. The Sort Level dialog box appears.
  3. Choose the State field from the Field drop-down list. Report Builder displays State in the Sort Field selection list.
  4. Choose OK. The Sort Order dialog box reappears with the newly defined sort order.
  5. Choose OK to return to the report layout.

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