You need your summary field to be in the same table as your InvoiceData::Amount field. That way it can summarize that amount, and be divided by a subsummary and leading grand summary.
Nested order looks like this:
Leading Grand Summary
Leading Sub Summary
So if I had two invoices, with two $100 transactions on each invoice, my sorted order grand/sub summary parts would be:
Total of All Invoices - $400 <--This is InvoiceData::Total
Total of Invoice 1 - $200 <--This is also InvoiceData::Total
Invoice 1 Record 1 - $100 <-- This is InvoiceData::Amount
Invoice 1 Record 2 - $100 <-- This is InvoiceData::Amount
Total of Invoice 2 - $200 <--This is also InvoiceData::Total
Invoice 2 Record 1 - $100 <-- This is InvoiceData::Amount
Invoice 2 Record 2 - $100 <-- This is InvoiceData::Amount
So I think you need to move your Invoices::Total field to your InvoiceData table, and create a leading grand summary with that total field in it, and you should be fine.
If that still doesn't make sense, please post a demo we can look at.
thanks for your answer
I understand what you say and also did it successfully,
Seen this is the only way to show report that I want. besides [invoice data] tab will fatter.
Thank for your answer again.
besides [invoice data] tab will fatter.
Not sure what this means, but I'm glad you were able to figure it out!