Progress
Report Builder
Tutorial
Creating Additional Band Lines
The first task in designing the report layout is to create the additional band lines you need for displaying the data. You must:
Creating Group Header and Group Footer Band Lines
Group header band lines are band lines that display header information for each group. Group footer band lines are band lines that display summary information for each group. When you specify the group order in the Group Order dialog box, you specify how you want to group the data for the report. The group header and footer band lines allow you to present the data in the specified groupings. Because you can specify multiple group levels, you can create group header and group footer band lines for more than one group in a single report.
For example, in this report you are grouping the data first by sales representative, then by order number. To display each sales representative’s orders and commissions, you must create group header and footer band lines.
Report Builder indicates band line type in the band line status area on the report layout and in the Create Band Line dialog box. Because you can create group header and group footer band lines for multiple group levels, Report Builder uses the format shown in Figure 7–2 to identify group header lines.
Figure 7–2: Group Header Label Description
![]()
Report Builder identifies group footer band lines the same way, except it replaces “GH” with “GF” (for group footer).
Follow these steps to create group header and group footer band lines:
- Choose Create
Band Line. The Create Band Line dialog box appears.
- Type 5 in the Number To Create field.
- Activate the Different Type radio button.
- Select 1GH–Sales–Rep from the drop-down list.
![]()
- Choose OK. Report Builder creates five group header band lines for the first group level.
- Create seven 1GF–Sales–Rep group footer band lines in the same manner.
- Create one 2GF–Order–num group footer band line in the same manner.
Create Additional Title and Summary Band Lines
In addition to the group header and footer band lines, you must create additional title and summary band lines.
Follow these steps to create title and summary band lines:
- Choose Create
Band Line. The Create Band Line dialog box appears.
- Accept 1 for the Number To Create field.
- Activate the Different Type radio button.
- Select Title from the drop-down list.
- Choose OK. Report Builder creates one more title band line.
- Create three more summary band lines in the same manner.
After you create all the band lines, the report layout should look like the one shown in Figure 7–3.
Figure 7–3: Commission Report Layout with All Band Lines
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |