Combine multiple SSRS Report and publish that to SSRS native web portal

Question

How can i combine couple of rdl reports and display that to SSRS native web portal. I already created that report and deployed to the server (SSRS Native portal) using Sql Server data tool 2015. But my client wants to view all reports in the same window. Although all reports has the same parameter.enter image description here enter image description here

enter image description here

Answer 1

The SSRS native web portal doesn't contain a mechanism to link multiple reports and run them on the save page via shared parameters (or anything even like that).

You have two options:

1. Create the merged report yourself. You should be able to import (or copy/paste) the datasets from each report into a new report, link them all one one set of parameter(s), and copy paste the content of each report (then fix all broken references).

2. The option above is the naive way to merge three reports into one. Instead, you could create a new master report, add the shared parameter and then add each additional report as a subreport to the parent report. Tutorial here.

3. Create an ASP.NET application that wraps the multiple reports into a single page. This will be quite a bit of work if you have never done this, but you would be able to create a custom parameter(s), pass the parameter(s) into the each report through code and render the multiple reports on a single page.

I would recommend option number 2.