Database Reference
In-Depth Information
22
Click
<<e x p r e s s i o n>>
. In the
Expression Elements
list, click
Sales By Category
subreport
, and then in the
Expression Categories
list, double-click
ProductSales
.
You have built an expression that calculates the total of the ProductSales values.
23
Click
OK
to close the
Expression Builder
and enter the calculation both in the
unbound control and as the
Control Source
property in the
Property Sheet
pane.
Let's make the two controls in the Report Footer section match the locations and
sizes of the controls in the Detail section.
24
With the calculated control still selected, on the
Format
page, set
Font Size
to
9
and
Font Weight
to
Bold
.
25
Set the
Format
property to
Currency
, and change the
Left
property to
3.5”
.
26
Click the
Total
label control, and change its
Left
property to
1.3”
and its
Width
property to
2.125”
.
27
Switch to
Print Preview
to examine the results.