Hello Cathy,

Can you do what he is asking using the method you are proposing? This would be a (cool) feature of the report writer I'm not aware of. I snipped out the first part of his example, which was not the way he wanted to do it.

Every time I've asked you something like this before, you've said "yes", and you were right. :)

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