MS Access for the Business Environment: Reporting in MS Access: Grouped Transactional Report Part II - Page 8
October 6, 2003
Working with the Customer Header and Footer Sections
The next header and footer sections with which we will deal in the Customer Orders Report will act to group order information by customer. The Customer header and footers will enclose the OrderDate group, within which lies the Detail information. The steps involved in setting up this part of our report will be quite similar to those of the OrderDate sections that we assembled above, once again occurring within the Design View for the report.
1. In the Field List, click the CustomerID field.
2. Hold down the SHIFT key, to allow the simultaneous selection of contiguous fields.
3. Click the CompanyName field.
4. Drag the fields together to the CustomerID section.
5. Drop the fields / controls at a point in the upper left hand corner of the CustomerID header.
6. Align the compound control approximately with the 1/8-inch tick on the horizontal ruler, as flush to the top of the CustomerID section as possible.
7. Right-click the CustomerID label control.
The Properties page for the CustomerID label control appears, with the Format tab as the default view.
8. Modify the Caption to read as follows:
9. Change Font Weight to Bold.
The Properties sheet - Format tab for the CustomerID label control appears as depicted in Illustration 28.
10. Close the Properties sheet.
The Properties sheet disappears.
11. Click the CustomerID text control to select it alone.
12. Pass the cursor over the Move handle for the control CustomerID text control, until the pointing finger image appears.
13. Click and drag the control to the immediate right of the CustomerID label control.
14. Click the CustomerID label control to select it.
15. Resize the CustomerID label control to fit the new caption (the right border of the control will align approximately with the 3/4-inch point on the horizontal ruler).
16. Move the CustomerID text control again to adjust its position to the immediate right of the CustomerID label control.
17. Resize the CustomerID Text control so that its right border aligns approximately with the 1-1/4 inch point on the horizontal ruler).
18. Click the label control (once again, the left control in the pair) for CompanyName.
19. Press the Delete key.
The CompanyName label disappears, leaving only the associated text control.
20. Click the CompanyName text control to select it.
21. Move the CompanyName text control to the immediate right of the CustomerID text control (aligning it approximately with the 1-1/4 inch point on the horizontal ruler, and to the top of the CustomerID section).
We need, once again, to size the section to ensure that our CustomerID header is presented in compact fashion.
22. Move the pointer to the bottom of the CustomerID header section, placing it between the CustomerID header section and the OrderDate header section.
The pointer becomes a "double-headed arrow," indicating that it is in position for dragging the CustomerID header section border to the desired position.
23. Hold down the left button on the mouse, as soon as the "double-arrow" image appears.
24. Drag the CustomerID header section border up, until a tight fit is achieved for the controls we have included.
25. Release the button to fix the border in place.