I recently had the same problem and figured out how you can get the same result with a different approach. You need to move the column footer elements into the Summary band on the report.

The problem would seem that this will come after the page numbers (or whatever else you have in the page footer). Fortunately, this isn't the case so long as you uncheck the Summary on New Page option. This is found in the root report element.

This will have the summary put only on the last page, right at the end of the data.