I'm trying to total a number of items in SSRS 2005. I'm putting my totals in the page as indicated here http://msdn.microsoft.com/en-us/libr...93(VS.80).aspx
. I'm also using a visibility expression to ensure the totals only appear on the final page. My problem is that my totaling expression only totals for the last page as I have a number of page breaks in the report. Any suggestions as to how to force a total for the whole report and ignore the page breaks?
At the end of the report in the footer I'm using:
The problem is, it does not grab values from previous pages before the page breaks. Microsoft mentions this in the MSDN guide and I wanted to know if someone has a workaround.