OK, I’ve got the grand total in the Page Footer of my Report by using a text box with the accumulation formula for the amtdue column.
So… how do you get a sub-total of one of the columns inside a grouping I have added for the amtpaid column? I have tried to add a text box with accumulation formula inside an amtpaid footer area but that doesn’t work as all it gives is a total for each row in a grouping.