SSRS - Two different reports in one Excel?

Question

I am pretty new to SSRS, so forgive me if I am asking something that is either obviously not possible (or easy) - I haven't found what I am looking for so far!!

I have a Detailed report, which splits by group onto multiple Excel tabs (pages). I also have a separate Summary report which outputs onto one page.

I want to merge these two into one report, so the users receive just one email, with tab 1 showing the Summary report and tab 2 on wards showing all the Detail.

The datasets come from two stored procedures and whilst related, they are different so I can't use the same dataset.

Is this possible in SSRS?

Thanks

Mark

Answer 1

Take your Detailed report and insert a subreport at the start of it. Set the subreport properties to point your Summary report.

If you have any manually set parameters in the Summary report, you'll need to set them up in the Detailed report (if they don't already exist) so you can pass the parameters to the subreport.

Now you have a single report with everything in.