>>>>I haven't done VFP in a while. A client asked me to add a series of total on the last page of a report.
>>>>
>>>>On the report footer, for each state (field d_state) he would like a summary row totaling
>>>>
>>>>TotalRows for state
>>>>d_amount
>>>>d_gross
>>>>d_net
>>>>d_buf
>>>>
>>>>Again, all of this needs to be in the report footer.
>>>>
>>>>
>>>>Like I said, it's been many years since I worked on a VFP report. Can someone point me in the right direction?
>>>>
>>>>Thanks
>>>
>>>The simplest way is to use Summary band. However, summary will not necessary be in the footer. You can use footer and add print when condition of recno() = TotalNumberOfRows.
>>
>>
>>
>>I don't think I understand.
>>
>>In the Report Footer, there will be any number of rows in this format:
>>
>>

>>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?