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