I'm having a hard time getting summary reports running on the child table to total correctly.
I'm trying to write a report which is "Total Expenses by Customer, Detail".
3 Tables to think about: Customers, Expenses, Items.
The report runs from an Items layout, because I want to show all the items.
Relevant fields are:
Expenses::Total_cn = Sum (Expenses_Items::Cost_n)
Expenses::Total_sum = Summary fields totalling Total_cn
I have a summary fields sorted by Customer::CompanyName. If I use the Total_sum in this subsummary, it doesn't add up correctly.
I can make it work by by creating a self relationship on the Expenses table based on the customer_id.
But I'm wondering if there is a simpler way to do this.
And no matter what I try, I can't get the Trailing Grand Summary to add up all the totals for different customers.
I can, of course, get the summaries and grand total to work if I run the report from the Expenses table. But I also need a detailed report.