Progress
Report Builder
User’s Guide
Group Order Attributes
The Group Level dialog box contains the following options for each group field:
By default, each of these options is deactivated. To activate an option for a particular group level, click the appropriate toggle box. The following sections explain each of the group options.
Print Once
Print Once suppresses the printing of repeating data on record band lines. By default, data from a selected group field prints on every line that includes that field. For example, if you group the records in a report by customer name (Name) and order number (Order-num), the records print by default as follows:
However, when you activate the Print Once toggle box, Report Builder prints the customer name and order number only once for each group. For example, the previous report prints as follows with Print Once enabled:
Reset Page
You can reset the page number to 1 and start a new page for each group. By default, Report Builder numbers report pages consecutively. However, if you activate the Reset Page toggle box, Report Builder restarts the page numbering at one for each group. For example, if you are printing a series of invoices grouped by order number and each invoice contains several pages of items ordered, you can start numbering the first page of each invoice at page 1.
Swap Header
When you create a report layout that contains a group header band, you can activate the Swap Header toggle box to print the group header band instead of the page header band on pages where the group changes. By default, Report Builder prints a group header before the first record for each group and places the page header at the top of each page. When you specify to use a group as a swapped header, you instruct Report Builder to use the group header for the first page of each group and the page header on all other pages.
To swap headers, the group header must have the same number of lines as the page header, since it substitutes for the page header on some pages. Group header and page header band lines must also have the same line height. Figure 9–1 shows how swapped headers work.
Figure 9–1: Swapped Headers
![]()
For example, activate the Swap Header toggle box to print customer order information grouped by order number, with the company name and customer information at the top of each page on which a new name begins. When you activate Swap Header, Report Builder prints the group header at the top of the first page of the group (each group begins on a new page) and then prints the page header at the top of each subsequent page in the group.
See the invoice chapter of the Progress Report Builder Tutorial for an example of how to use swapped headers.
Swap Footer
When you create a report layout that includes group footers, you can activate the Swap Footer toggle box to print a group footer instead of the page footer on each page containing the last record in a group. By default, Report Builder prints a group footer after the last record for each group and places the page footer at the bottom of each page.
To swap footers, the group footer must have the same number of lines as the page footer, since it substitutes for the page footer on some pages. Group footer and page footer lines must also have the same line height. Figure 9–2 shows how swapped footers work.
Figure 9–2: Swapped Footers
![]()
This is especially useful when you are reporting on preprinted, multi-page forms, such as invoice forms. For example, you can use this option when printing invoices that group many pages of items by order number. In that case, for each invoice, each page but the last contains a page footer that includes a page total. However, the last page of each invoice contains the group footer with the grand total for the entire invoice.
See the invoice chapter of the Progress Report Builder Tutorial for an example of how to use swapped footers.
Repeat Header
Repeat Header allows you to reprint a group header at the top of the page when a group continues across several pages. By default, Report Builder prints the group header only once at the beginning of each group. When you activate the Repeat Header toggle box, each time Report Builder starts a new page it prints a page header, if any, and then repeats the group header before printing more data within the group.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |