Have another quick report question for you all
I have two tables - Customer -> Invoices
I have a report based on the customer table. It also is showing related data from the invoices table in it. This all works fine. I want to have a summary at the bottom totaling up the invoices, this isnt working.
Is it not possible to have related fields used in a sub summary part? (These are summary fields)
Looks something like this:
Customer 1 Invoice Amount: $100.00
Customer 2 Invoice Amount: $500.00
Total $600.00 (this part doesnt work)