I have a report that shows all invoiced items and not yet billed items for a job. The report is grouped on invoice number within job number. So general layout is:
invoice item detail
invoice footer (showing invoice totals)
job footer - including sub report of unbilled items for this job plus job totals
report footer (showing grand totals for all jobs)
The subreport mentioned needs to come after all invoices for current job, and before job totals. It details all not yet billed items for current job.
Immediately after this subreport the job footer also shows job totals, including totals collected in the unbilled items subreport. These are gathered in global variables.
My problem is that the job footer format event is triggered BEFORE the subreport is formatted and so the unbilled totals are need are not calculated yet.
Any ideas of how I could manage this?