Summing a Cross Tab in Report Footer

[Tammy]

I've got a cross tab report with dates across the top and project# down the side and value in the body. I have two challenges.
1. I need to summarize the cross tab findings in the report footer (not that big of an issue but....) 2. Each time I run this report there will be new months as data is added to the database. This is where things get tricky because with each new month I'm going to have to delete the previous month and add a new month to all the formulas and functions that are built in to get the totals in the report footer. I'd like this to be as automated as possible but I'm not seeing and easy path forward.

Any suggestions?

Tammy

[June7]

Building report to run perpetually based on crosstab is not easy, as you have discovered. Review http://allenbrowne.com/ser-67.html#ColHead