>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. :)
I went back and reread this thread and realized that I completely missed the point that he wanted the subtotals on the same line as the last detail line of each invoice. The solution I provided wouldn't exactly do this ... but ... I do have a suggestion that would work. Create a report variable called rlEndOfInvoice and initialize it to .f. In the expression of the report variable .. call a UDF such as IsLastInvoice(). Create a UDF that does something like this...
lEnd = .t.
lnInvoice = MyTable.InvoiceNumber
IF NOT EOF()
SKIP
lEnd = (lnInvoice <> MyTable.InvoiceNumber)
SKIP -1
ENDIF
RETURN lEnd