Microsoft Office Tutorials and References
In Depth Information
2.
In the Group, Sort, and Total pane, click to the left of the group band to select it,
click
More
to expand the band and display all group options, click the
keep header
and first record together on one page
arrow, and then click
keep whole group
together on one page
, and then close the Group, Sort, and Total pane.
You’ll start improving the report by moving the InvoiceItem text box to the left in
the InvoiceItem Header section and setting its font to bold.
3.
Select the
InvoiceItem
text box in the InvoiceItem Header section and the
InvoiceDate
text box in the Detail section, align the two selected controls on their
left edges, hold down the
Shift
key, click the
InvoiceDate
text box to deselect it,
release the
Shift
key, and then in the Font group on the Design tab, click the
Bold
button . The InvoiceItem text box is displayed as bold text.
The report width is 8 inches, and Sarah will want to print the report on standard
8.5" × 11" paper, so you’ll change the page orientation to landscape, and set the
left and right margin widths to 1.5 inches each.
4.
Click the
Page Setup
tab on the Ribbon, and in the Page Layout group on the Page
Setup tab, click the
Page Setup
button to open the Page Setup dialog box, click
the
Page
tab, click the
Landscape
option button, click the
Print Options
tab, set
the Top and Bottom margin properties to
0.7
and the Left and Right margin prop-
erties to
1.5
, and then click the
OK
button.
The text boxes in the Detail section are crowded together with little space
between them. Your reports shouldn’t have too much space between columns, but
reports are easier to read when the columns are separated more than they are in
the rptInvoicesByItem report. Sometimes the amount of spacing is dictated by the
users of the report, but mostly it’s the report designer’s choice to make. First, you’ll
remove the Paid label and the InvoicePaid text box from the tabular layout, resize
them, and move them to the right.
5.
Select the
Paid
label in the Page Header section and the
InvoicePaid
text box (it
contains a check box) in the Detail section, right-click one of the selected controls
to open the shortcut menu, point to
Layout
, click
Remove
to remove both controls
from the tabular layout, deselect the
InvoicePaid
text box, right-click an edge of
the
Paid
label to open the shortcut menu, point to
Size
, click
To Fit
, and then
move the label to the right until its right edge is at the 8-inch mark on the
horizontal ruler.
6.
Click the
InvoicePaid
text box in the Detail section, decrease its width until it’s
slightly wider than the check box inside it, and then move it to the right until the
check box is centered under the Paid label. See Figure 7-26.
To move the remaining bound controls, you first need to remove them from the
tabular layout.
7.
Select the
InvoiceAmt
text box and the other three controls in that column, right-
click the
InvoiceAmt
text box, point to
Layout
on the shortcut menu, click
Remove
, deselect all controls except the
Invoice Amt
label in the Page Header
section, right-click the
Invoice Amt
label, point to
Size
on the shortcut menu,
click
To Fit
, select all controls in the column, right-click one of the selected con-
trols, point to
Align
on the shortcut menu, click
Right
, and then move the selected
controls to the right. See Figure 7-26.
8.
Refer to Figure 7-26 and repeat Step 7 for the
ContractType
,
City
, and
Customer
bound controls, in that order, but do not align the bound controls on their right
edges. See Figure 7-26.
Tip
You usually determine page
setup properties when you
design a report or, as in
the case of this report,
after you’ve placed the
controls in the Detail
section.
Tip
You can resize labels and
controls added with the
Label tool to fit, but you
can’t resize text boxes
to fit.
