Subreport spanning mulitple pages with page total on each page

[Chris]

Hi,

I have a report containing a subreport with figures that I want to subtotal on each page (for only the figure displayed on each individual page) and then I want a grand total for the subreport figures on the last page (all figures across all pages).

Currently I have the grand total working but unfotunately I cant find a way to do a subtotal per page. I basically need something like how the PageExec() works to allow me to sum up the data on that page, but obviously subreports dont have a page footer so this doesn't work. I have tried the Exec() but I can't set the scope to only the data on the page. Maybe if there was a way for passing the Exec() a scope with just the data on display on the page this would work but I guess the PageExec() was built to do this but without subreports in mind.

Please can anyone help me with this problem?

Thanking you in advance

[Peter]

Hi Chris,

The PageExec(itemName, aggregateFunction) can accept subreport's report item as itemName. Thus you can add a PageExec function to the master report's page header that references subreport's report item. For an example check out the Invoice demo report that came with your installation of Telerik Reporting.

Regards,
Peter
the Telerik team