Calculate a Running Summary

This tutorial describes how to calculate a running summary across report groups.

A running summary adds the current summary value to the previously calculated summaries:

How to -  CalculateRunningSummary2

Do the following to calculate a running summary in a report:

  1. Start with a report that is bound to the sample Northwind database's Products table (the nwind.mdb file included in the XtraReports installation). See Provide Data to Reports for information on how to bind a report to a data source.

    HowTo_CalculateRunningSummary0

  2. Add the GroupFooter band to the report to display a summary at the bottom of each group. For example, you can use the Group and Sort panel.

    How to - CalculateCustomSum_0a

  3. Drop the UnitsOnOrder field from the Field List onto the created band.

  4. Click the label's smart tag, and in its actions list, set the Summary property to Report to calculate the running summary across the report.

    Set the Expression to sumRunningSum and specify a format string.

    HowTo_CalculateRunningSummary1

A complete list of available functions can be found at Functions for Summary Expression Editor.