Calculate a Summary
This tutorial describes the steps required to calculate one of the built-in summary functions in your report.
Warning
Use the approach below if expression bindings are not enabled in the Report Designer (the Designer does not provide the Expressions panel).
See Calculate a Summary if expression bindings are enabled in the Report Designer (the Designer provides the Expressions panel).
Create a new report or open an existing one and bind it to a data source.
Insert the Group Header band, select the Group Fields section in the Actions category and add a new group field to group the report's data by the required field.
Insert the Group Footer band. Prepare the report layout and drop a required data field onto the group footer to display the summary result.
Select the label, expand the Summary section in the Actions category and invoke the Running drop-down list. Select the range for which to calculate a summary (the entire report, a specific report group or document page).
Set the Function property to Sum and use the Format String property to format the summary's value.
Switch to Print Preview to see the result.