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