>>>>>

>>>>>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.
>
>
>I need more help...
>
>I created a summary cursor, but I don't see how to create a Report Footer band. I do see a Summary band. Is this the Report Footer?
>
>I added fields to the Summary band from the summaries cursor, but none of them show up. The whole band doesn't show.

You don't want Page Footer (there's no such thing as Report Footer) or Summary. You want a second detail band. Right-click in the report and choose Optional Bands. On the right-hand side of the page that opens, click Add, then click OK.

You'll see that the report now has two detail bands. Double-click each one in turn and fill in the Target Alias Expression with the name of the cursor for that band in quotes. (VFP is looking for an expression there, not an alias.) In the same dialog, you can specify that the detail band has its own header and footer, if you need them.

Tamar