How to use the Cumulative Function in the Report Viewer

The cumulative function typically calculates the running total or cumulative sum of a sequence of numbers.

Currently, the cumulative function is available only for flat tables. You can achieve the cumulative function by either using an expression or assigning the Custom property. If the expression is used below the detailed row of the table, it will show the current page plus the previous page total. If it is used above the detailed row of the table, it will show the total of the previous page; in the case of the first page, the total will be 0.

By expression:

Syntax:

=cumulative(numerical field of the dataset, dataset scope name)

Description:

Returns the total sum of the detailed rows rendered before.

By custom property:

Assign the Custom property to the textbox Property Name: Cumulative and set the value to true.

Limitations:

1. Can be used only in the flat tables.
2. Cumulative expressions cannot be used within other expressions.