I have a report that has three grouping levels: month, week, and days.
In each of the footers for these groups I calculate a sum.
If the number of records for a given week won't fit on one page, then I
get a total for whatever of that week is on the first page, and then I
get another total for whatever's left on the second page.
I've played with the groups' properties and looked in help, but I can't
find a solution to my problem. I need one total for the week no matter
how many pages that week covers.
Thanks in advance for any suggestions.
-Josh Nikle