Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900