Subreport totals resetting when going to new page
I have a report with the following structure:
RPTRing
-> RPTHole
-> Decks
Rings and Holes are joined by a relation. Decks are a sub table within Holes.
I have a page for each Ring and then a subreport for the Hole/Deck table. I have Totals at the bottom of the subreport and they work fine for each page except when the subreport crosses over to a new page and then the totals start at zero again.
This discussion has been closed.
Comments
This picture shows the total as 270 which only include the values in that column of that page. It is missing all the values from the previous page.
Hello!
The ‘Total’ value within a subreport is reset when moving to a new page if the ‘Total’ properties specify a reset band or event that triggers on a page break (for example, `ResetOnReprint = true`, or if the total is linked to the subreport’s `PageFooter` or `Header` rather than its `DataFooter`).
To test this:
Place the total output in the DataFooterBand at the bottom of the table within the subreport (rather than in the PageFooter).
In the Total settings, specify:
Evaluator: your DataBand within the Subreport
PrintOn: your DataFooterBand
ResetAfterPrint = true, ResetOnReprint = false (key setting: it is specifically ResetOnReprint = true that resets the total when moving to a new page).