problem with reports

[Steven]

I have created a report that is almost formatted correctly, but I am
not sure how to tweak it so that it has the correct format.

Currently it looks like this:

program name, budget no., amount (in the program name footer)
program name, budget no., amount
program name, budget no., amount
budget no., subtotal (in the program budget footer)
program name, budget no., amount
program name, budget no., amount
program name, budget no., amount
budget no., subtotal
grand total (in the report footer)

I need to regroup the report, so that it has the following layout:

program name, budget no., amount
program name, budget no., amount
program name, budget no., amount
program name, budget no., amount
program name, budget no., amount
program name, budget no., amount
budget no., subtotal
budget no., subtotal
grand total

Is this possible? How should I change my groupings? Just a note, the
subtotals and grand total are caluclated by just summing the amounts.

Thank you for your help,
Steven

 

[Duane Hookom]

If I understand correctly, you may need a subreport that is based on a
totals query. Place the subreport in the report footer.