Featured Database Articles

Working with the Customer Header and Footer Sections

The next header and footer sections with which we will deal
in the Customer OrdersReport 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:

Customer:

9.
Change Font
Weight to Bold.

The Properties sheet - Format tab for the CustomerID
label controlappears as depicted in Illustration 28.

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 CustomerIDText 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.