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