Calculate a Summary

Aug 09, 2018
2 minutes to read

This tutorial demonstrates how to obtain a total price within each detail report by calculating a summary for a data-bound label control using a built-in function.

Do the following to accomplish this task:

Select the detail report and add a Group Footer by switching to the Properties panel and clicking the Insert Group Footer Band button in the Actions category. This allows you to display a summary at the bottom of each detail report
Drop the Label control from the Toolbox onto the created Group Footer.
Select the newly created label and expand the Actions category in the Properties panel. In the Summary section, set the Running property to a value that specifies the range for which to calculate a summary (the entire report, a specific report group or document page). Then, click the Expression property’s ellipsis button, and in the invoked Expression Editor , select the required summary in the Functions | Summary section.
Specify the summary label’s appearance settings (for instance, make the font bold). Use the Line controls to separate the field captions and summary value from the detail data.

Click the Preview toolbar button to view the result.