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.
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.