How to Merge Multiple SSRS reports into 1 with Multiple Headers and Footers RRS feed

  • Question

  • I have multiple SSRS reports and I need to merge it into 1 big report with multiple headers and footers so that I can have the paging setup correctly.
    Does anyone know how I can achieve this?

    Wednesday, June 3, 2009 5:21 PM

All replies

  • One way to create a single report and add all those subreports to the main in sequence as per your display order. You can configure page size and details you want.

    Thursday, July 19, 2012 1:07 PM
  • My solution is to render all of the reports as PNGs and embed their bytestreams into a new programatically built rdl.  This lets me cache report parts and do other fun things.

    But an easier way would be to make a master report with sub-reports built into it and string replace your target reports into the right spots.  If the target subreports are always the same ones, then you don't even need to string replace stuff.

    Monday, July 23, 2012 3:21 PM