I have 3 different reports each with multiple totals, I want to generate a single report as a summary report. One way I was thinking about doing this was to insert the values from those totals fields into a new table but I dont know how to link the 3 reports so that each value appears in the same new record. Is there a way to create a unique identifier for each report and insert the total values into a new table and then I can query the new table? or what is the best way to do this?
I have 3 reports named: LaborQuoteR, InventoryAddToQuoteR, SubcontractsR. I have grand totals for each.