GetSummary

[mav]

Here's the little problem I am having, I was hoping you guys and gals could help me out.

The file has two main scripts, one to go into preview mode (and sort by company) for the sub-summary layout report, the other script to go back to Invoice layout as Browse mode.

I've read the usage of the GetSummary function, where I think that the break field is not doing what it should, as the field is blank.

It would be great if someone could solve this one . . .

summary.zip

[comment]

Yes, unfortunately the break field must be in the same table - so define an unstored calc field = Invoices::Company and change your GetSummary(), your sub-summary part and your sort to use that.

[mav]

Thanks again Comment.

Once the company field was in the invoiceitem table, and the sort and break field were based on this field, it works.

It's an unfortunate limitation of the break field, as the sort field can be in any table.

I've updated the file, to show how profitable a Company's Invoices have been for the Report, followed by the percent of overall profit for this company.

summary.2.zip