Combine 9 SSRS reports into one report

[donalexander]

Hello,

I am using SSRS - 2014 my IT manager challenge me to combine 9 reports into 1 report. In another words have the user just enter the dates of the report and press View Report all 9 reports will be printed. I am not sure how to go about it. Here is my idea:
Create a SSRS report with date parameters not all reports will use the same date parameters, fortunately all of the reports have same parameter names. Add the nine reports as sub reports. Here is my concerns:
• How would it print out? Do I have to size the sub reports?
• Would the sub reports look good (I have some graphics on some reports)
• Would all the 9 reports pick up the parameters from the main report?

Anybody who had similar issues, please let me know and what approach you have created. I appreciate the help. Thank you in advance.

 

[Jacque]

I don't know if you ever got this accomplished but I have done the same thing, 6 reports total, not 9 though.

I made a master report with the main header and footer of the report to be shared by all of report including the subreports. The header contains my companies dynamic logos and the selected clients logo (also dynamic). They all look clean although you might need someone or some tool to manipulate the logos/image sizing.

There are charts on all pages and they look good.

On the main page below the master report and above the report footer, I added a rectangle for each subreport - one of my rqmt was to each report had to have it's own page(s), so I conditionally set pagination for breaks on that and added page breaks in groups of each subreport.

All of my report parameters are named consistently and are passed as needed to the applicable subreport(s).

My reports prints cleanly, in the order requested and each page is a separate report.

Hope this helps.

 

[donalexander]

Jacque,

That is what I did also, but I did not put rectangle in my report it comes out nice. I had to have the user be content without the subreports name. Thanks for taking the time in replying. At least I know I am not the only one doing that.

Cheers