How calculate a page running value in Telerik Reporting

[garri]

In Telerik Report Designer, I am having the worst time trying to figure how to find a proper scope name to get the sum of a given expression for every dataitem processing until the end of each page.

For the sake of simplicity, my datasource only has 1 column: saleAmount.

Sample values that fit on page 1

• 100
• 200
• 150

Footer running sum of page 1: 450

Remaining values that fit on page 2

• 20
• 30

Footer running sum of page 2: 500

According to this Telerik Reporting article, it seems I should use RunningValue(scope, Sum(Fields.saleAmount))

I've already spent a significant time trying to figure out what exactly should I use as scope parameter,

Please see the attached sample (MyPageRunningTotalSampleReport.zip)

[garri]

I've prepared a sample report using json data and updated my question, so to make it clear what I aim to achieve

[garri]

I've update sample report, since the was a typo on detail section RunningValue

[Momchil]

Hello Luis,

Indeed, this scenario requires some extra steps as the RunningValue data function alone is not sufficient. The Summary Per Page Knowledge Base article describes how you can get the running sum to appear in the page footer section of the report.

The KB article contains a sample report you can test, as well. For your convenience, I am attaching the sample to this message.

You will notice that the report relies on some Custom User Aggregate Functions so make sure to build the project in the attached demo and Extend the Report Designer with the generated assemblies first.

Best Regards,
Momchil
Progress Telerik