Just answered my own question! I needed a summary field in my table. Out of interest is there anyway to calculate a field 'on the fly within the report'?.
Out of interest is there anyway to calculate a field 'on the fly within the report'?.
Probably, but you'll need to be more specific than that.
I'm actually having the same issue now. I'm showing data in my report from 3 tables: customers, jobs and job line items. Layout is based on jobs.
The body contains, job#, customer company, line item description and job total (this is a summary field totaling all related line items with no options checked)
The report wizard put a grand total field at the bottom automatically, however it's only showing the amount from the last record.