1.
No calculated/summary fields can go into the page footer, meaning no SUM or COUNT, but you can refer a textbox or object in the report and print its value.
2.
Since the pages are in columns, there is no way to make a report summary that does not cause a page break, otherwise it will be as wide as the last column printed, so I left the summary at the page footer level.
3.
OK, you have to trick the report by using the data, since we do not want to do a summary at the report footer level because it would cause a new empty page, we need to create a 'fake' or wrapping grouping by adding a constant field to the query (set to zero), then you summarize at this level, instead of the report level. The sum and counts will give you the same results, and the footer for that group is set to visible=false


You got the file in email...