Database Reference
In-Depth Information
You have formatted the two controls in the Detail section of the subreport.
Next let's create a summarizing function that will calculate the total of the
ProductSales values in the subreport's Report Footer section.
16
In the
Property Sheet
pane, change the control selection to
Report Footer
, set its
Height
property to
0.333”
, and press
Enter
. Then scroll the subreport until the entire
Report Footer
section is visible.
17
On the
Design
tool tab, display the
Controls
gallery, click the
Tex t Box
thumbnail,
and click in the center of the
Report Footer
section to insert an unbound control and
its label.
18
Select the label of the unbound control, and in the
Property Sheet
pane, set the
following properties:
Caption
Total:
Font Size
9
9
Font Weight
Bold
19
In the subreport, click the unbound control, and then on the
Data
page of the
Property Sheet
pane, in the
Control Source
property, click the
Ellipsis
button to
open the
Expression Builder
dialog box.
20
In the
Expression Elements
list, double-click
Functions
, and then click
Built-In
Functions
.
21
In the
Expression Values
list, double-click
Sum
to display
S u m (<<e x p r e s s i o n>>)
in the expression box.