>>>

>>>State     Rows        Amount     Gross      Net            Buff
>>>CA         10            15,000       25,000     18,000     10,000
>>>AZ           5             22,000      13,000      9,000       4,000
>>>MA        185           66,000      22,000      10,000     14,000
>>>

>>>
>>>
>>>What I don't know is how to produce rows like this in the report footer
>>
>>Looks like you may need to use multi-band report for that. I only have a few reports like that...
>
>Will the bands be auto-generated, meaning one band for each state?

No, I thought you can have the main cursor and another cursor with totals only which will be your second band.