>>>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...
If it's not broken, fix it until it is.
My Blog