Progress
Report Builder
Tutorial
Designing the Group Header
The first section of the report layout you are going to design is the group header or swapped header. Because you defined the Order–num group to start a new page, the group header, 2GH–Order–num, contains the information that appears on the first page of every invoice.
To produce the information shown on the first page of the invoice in Figure 9–8, you must perform these tasks:
Inserting the Fields
The first task in designing the group header is to insert the database, calculated, and text fields on the layout.
- Type All Around Sports on the third 2GH–Order–num band line, then make it 18-point Arial, bold, italic and center it on the band line.
- Insert the database fields with their labels at the position indicated in the following table. Position the left edge of the field at the specified ruler mark:
Make sure that the Insert Field Label option is selected. When you insert the fields, Report Builder places their labels on the band line directly above the fields. You will reposition the fields onto the same band line with their labels in a later section.
- Insert the calculated and database fields without their labels at the positions indicated in the following table. Position the left edge of the field at the specified ruler mark:
Field Band Line Ruler Mark Name Fifth 2GH–Order–num 5-inches Address Sixth 2GH–Order–num 5-inches Address2 Seventh 2GH–Order–num 5-inches City–State–PC Eighth 2GH–Order–num 5-inches- Move the Order–num field to the 1-inch mark on the fifth 2GH–Order–num band line.
- Move the Order–num text field to the left margin of the fifth 2GH–Order–num band line.
- Create the following text fields on the twelfth 2GH–Order–num band line: Line No., Item No., Qty., Backordered?, Unit Price, Discount, and Extended Price.
- Change the alignment of the text fields you created in Step 6 from left to right.
After you complete these steps, the layout should look like the one in Figure 9–3.
Figure 9–3: Layout with Group Header Fields
![]()
Drawing and Modifying a Rectangle
When you inserted the database fields in the previous section, you inserted the field labels for the order information on the twelfth 2GH–Order–num band line. To highlight these labels, surround them with a rectangle.
Follow these steps to create and properly format the rectangle:
- Create a rectangle starting at the left margin and ending at the 7.5-inch mark (right margin) on the twelfth 2GH–Order–num band line. The finished rectangle should encase the text fields on the band line.
- Specify Silver as the rectangle background color.
- Create a vertical line that is the height of the rectangle at the 1-inch mark.
- Copy the line five times, then place one line at each of the inch marks, starting with the 1-inch mark and ending at the 6-inch mark within the rectangle.
For example, move the one vertical line to the 1-inch mark, then another line at the 3-inch mark, etc. These lines are dividers that create column header areas within the rectangle.
Make sure that all the vertical lines connect with the rectangle borders.
Figure 9–4 shows the layout with the formatted rectangle.
Figure 9–4: Layout with Shaded Rectangle
![]()
Formatting the Fields
When you formatted the rectangle, you placed the divider lines so that they created 1-inch areas within the rectangle. In this section you will center the column labels within these sections. You will also make all the other field labels in the group header bold instead of underlined.
Follow these steps to format the text fields:
- Change the point size of all the column labels on the twelfth 2GH–Order–Num band line from 12-point Arial to 10-point Arial.
- Center each column label within its area of the shaded rectangle by moving it to the appropriate location.
- Move the following fields to the location specified in this table. Position the left edge of the field at the specified ruler mark:
- Change the style for all of the field labels in the group header from underlined to bold.
After you format the fields, the layout should look like the one in Figure 9–5.
Figure 9–5: Layout with Formatted Group Header Fields
![]()
Specifying Conditional Printing for a Band Line
In "Commission Report," you learned how to conditionally print a band line based on the value in a field. For this report, you are going to perform the same task for the seventh 2GH–Order–num band line.
Follow these steps to conditionally print the band line:
- Select the seventh 2GH–Order–num band line.
- Choose Properties
Band Line Properties. The Band Line Properties dialog box appears.
- Activate the Enable Conditional Printing toggle box.
- Select the Customer.Address2 field from the drop-down list. By default, the Print When Field Has Contents radio button is activated.
- Choose OK to return to the report layout.
You are now finished designing the group header. Figure 9–6 shows the report layout with the properly designed group header.
Figure 9–6: Layout with Completed Group Header
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |