My system currently produces three distinct reports for all tenants on our mailing list. Once a year we do a mass mailing so we have three reports for over 9,000 tenants, and some poor sod (not me!) has to pull together all the reports relating to each tenant in turn. I have racked (and wrecked) my brain to find a way to print Report1, followed by Report2,and then Report3 for one customer, and then move onto the next customer and start again. Unfortunately, the reports are so radically different to each other that merging the data for each report into one large recordset is impossible. Any thoughts how to do this programmatically apart from printing each report in turn for one customer, and then regenerating each one in turn for each tenant?

Here's hoping

It might not be appropriate but have you considered using subreports... each of your three distinct reports would be a subreport, by client, hopefully... the parent report is merely a list of your clients, with the sub's hanging off each client...