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