Hi Cathy:

I know that you are the expert on VFP reporting (I attended some of your presentations at GLGDW), but your solution went over my head. Could you be a little more detailed?

Sorry,

Yossi

>Create a data group on Invoice Number. In the Data Group Footer, print the amount and mark it as SUM, reset on Invoice Number. Then create a Summary band and print the amount and mark it as SUM, reset on EndOfReport.
>
>
>>Hi All:
>>
>>How can I produce a report that has total information on the last detail line?
>>
>>Easy Report to do for invoices with multiple line items:
>>
>>

>>Invoice Number  Amount
>>10001           1,000
>>                2,000
>>                3,000
>>TOTAL           6,000
>>
>>10002           4,000
>>
>>10003           5,000
>>                6,000
>>TOTAL          11,000
>>
>>GRAND TOTAL    21,000
>>

>>
>>This I can't do, unless I run one pass through the file and mark each last line:
>>
>>

>>Invoice Number  Amount  Total
>>10001           1,000
>>                2,000
>>                3,000   6,000
>>
>>10002           4,000   4,000
>>
>>10003           5,000
>>                6,000  11,000
>>
>>GRAND TOTAL            21,000
>>

>>
>>Thanks!
>>
>>Yossi