How to calculate aggregates on every page when have many columns

[Hans]

Hello telerik

According to your examples, you know the location of elements, their values and element count.
But when I create report, I don't know how many columns will be in my report. Usually 20-40 columns.
A piece of code: (I write by hand, to don't copy the entire code)

//by default standard portrait A4
private void BuilderReport(Telerik.Reporting.IReportDocument report)
{
    report.Width = new Unit(Columns.Count * 1.2, UnitType.Inch); // ≈ 20-25 Inch

    // ...

    foreach (var column in Columns)
    {
        var dataTextBox = new TextBox { /* Size, Location etc */ };
        report.Items["detail"].Items.Add(dataTextBox);

        // ...
        var footerTextBox = new TextBox { /* Size, Location etc */ };
        footerTextBox.Value = string.Format(@"=PageExec(""{0}"", Count(Fields.{0}))", column.Name);

        // pageFooter is Telerik.Reporting.PageFooterSection
        report.Items["pageFooter"].Items.Add(footerTextBox);
    }
}

Only each first page contains correctly aggregate values, other pages contsins 0
If replace PageFooterSection to Telerik.Reporting.GroupFooterSection all aggregate items is equals 0

How correctly calculate aggregates, when have too many columns and they are transferred on other pages?

Thanks

[Stef]

Hi Hans,

Please check the Data Functions help article elaborating on how to use PageExec function. The first parameter is the item name for which will be executed the accumulation.

I hope this helps.

Regards,
Stef
the Telerik team

[Hans]

var dataTextBox = new TextBox { /* Size, Location etc */ Name = column.Name };

It is clear
Please, try to reproduce according to my code
I need help

[Stef]

Hello Hans,

As stated in the mentioned help article:

"PageExec(itemName, aggregateFunction) - executes the specified aggregate function in the given scope. As the name suggests, it can be used in page header or page footer of the report. In order to specify the scope in which the aggregate would be evaluated, you need to specify a report item as a parameter of the function."

Since you add items manually to the report document and if we assume in Print preview the items do not gather on a single page and are transferred to another page, the Count accumulation in the PageExec function will return 0, as it is not on the page, which is the correct behavior. In case you need aggregates per group, you can use the RunningValue function.

I hope this helps.

Greetings,
Stef
the Telerik team