Help with report
I'm having some trouble trying to make a report. I have customers --< projects ----< lineitems >----< invoices and would like to make a report on this along the lines of:
Project and costs
subtotal costs for company
Total costs for date period
Any ideas on which table to start from and what calculations needed greatly appreciated.