Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Group multiple reports into one in SSRS

I'm new to SSRS and I need the ability to group multiple reports into a single report. I've searched around a lot but not found much. I currently have two reports (more to come) that users need to be able to view/save individually. The users also need the option to view both those reports as a single report. Essentially just a simple concatenation. Eventually, there will be several reports grouped and the user will be able to render all of them for viewing online or saving as a single PDF.

I tried two sub-reports in a master report but it causes a lot of hard to diagnose page-break problems. I was wondering if there was a more straight forward option here. Thanks.

like image 356
Matt Molnar Avatar asked Sep 05 '12 20:09

Matt Molnar


People also ask

How do I link two reports in SSRS?

To create a linked report In the web portal, navigate to the desired report, right-click on it and select Manage from the drop down menu. On the Manage <reportname> page, select Create linked report.

How do I keep groups together in SSRS?

Select the Column Groups drop down, click "Advanced Mode" and then in Row groups highlight "Details". In Properties under the "Other" section, select "True" for Keep Together. and save.


1 Answers

Combining all the report elements into one report would work, but the users also need to be able to view them as individual reports as well. To avoid having to maintain both an master report and multiple individual reports, you have a couple of options:

  1. Create a master report and insert the individual reports as sub-reports. If you get page break issues, check the report page height and widths versus the subreport container height and width.

  2. (If you have SQL Server 2008 R2 or later) Consider publishing your individual reports as a set of Report Parts. You can then reuse these in a master report.

like image 138
Nathan Griffiths Avatar answered Sep 27 '22 18:09

Nathan Griffiths