I created a demo file. My question is how to create customer sales total without using ExecuteSQL. Go to the report and click customer report. And you would see my sql statement. Is there a way to do the same thing not using sql? If I export it to iPhone ExecuteSQL may not work....Thanks.

 

KC

Customer Sales Report.fmp12

Use a layout of the Invoices table. Find the invoices in the date range you want, with the payment status you want. Sort them by customer. Place a summary field totaling the invoice amount in a sub-summary by customer part. If you want to see only customer sub-totals, delete the body part of the report layout.

There is no need for a Report table (unless you need to track reports made or submitted).