Hello all - we have what I believe is a relatively unique report problem (using SQL 2008 Reporting Services). We have a system where a Customer can have multiple Sites. Each Site has the need to run a report, but each Sites reporting requirement is different - so there may be multiple report formats/objects across multiple Sites. Having each Site run their own report is easy, but there is also a requirement for the Customer (who "owns" the Sites) to be able to print a single report which includes the reports from each of the individual Sites - these need to be combined for the purposes of page numbering, mailing, and billing.
In normal cases this could be done as another report grouping or even a subreport. However, because the reporting format for each Site may be different this approach will not work. I think that it may be possible to add the different Site reporting formats onto the one "master" report (eg. if there are 3 different Site report formats, add the 3 individual reports as subreports in the "master") and then hide/unhide the appropriate subreport based on some setting that we create for the Site entity (ie. Site.ReportFormat).
Before spending hours messing around with this and getting nowhere I thought I'd throw this out there to see if anyone knows this approach will work OR if anyone has a better approach.
Thanks,
Chris