Hi

I have created an accounts receivable aging report with five categories (30,60,90,120,More than 120) and I am sorting for sub summary by account number and AR Category. My problem is that I want to total the AR Categories across all the accounts at the bottom of the report (total of all the 30 day accounts, 60 day accounts, etc.). Can anyone help with this one? Thank you.

G

For each category (30,60,90,etc...) I am assuming that you have a sub summary area created that totals your amount due. This area would have a summary field in it that provides a total of the amount due for that category only.

At the end of the report, create a trailing grand summary part and insert this same summary field. It will give you the total of each category as a grand total.

HTH