Hi there. Bit of an open-ended question. I'm implementing a solution for a client in an Oracle database using PL/SQL and Application Express, but there is a requirement to interface with MS Reporting Services and I'm not sure the best way to go about this. Basically, they have a set of reports in MS Reporting Services and there is a requirement for a certain combination of these reports to be printed in one go as a "pack", via a single button click on a web page. We have the ability to access a single report via URL and print this, but I'm not sure of my options for grouping these multiple reports into a single entity. I have read about sub-reports and wondered if creating a master report with references to each of the required sub-reports is a viable solution? I would then be able to have a link to this master report on my Application Express page, and in the background all the individual sub-reports would be populated and generated. Is that feasible? There is also a possibility that the contents of the pack of documents could be variable - eg using parameters "for this pack, I need 2 copies of document X and 1 copy of document Y". Would it be possible to make a number of calls to a subreport based on the value of a parameter? Eg by adding a loop etc? My other thought is to try and do the combination on the Oracle DB side. So I would make individual requests to the SOAP API to request the reports to be generated, and then if the API could return a report in some form, then I could perhaps have a procedure to stitch these together somehow. But I am skeptical about the API being able to actual pass a printable report back and forth, and unsure of the efficiency of making potentially 20+ calls to RS via SOAP. I'm off on my merry way to search through the web and forums, but thought I'd start by asking a general question and see if there was anyone who could help or could point me in the right direction. Many thanks, Dave

Hello, your sub report-master report could work provided that all the reports have the same page properties so they print consistently. But it may not work with with variable copy numbers. Another option is using a file delivery subscription. Setup a subscription for each report to send a copy to a directory. And then from there you are free to do setup whatever kind of script or service you like to get them printed the way you need.