SSRS Report Linked Reports


This article shows how to use a linked report for a SSRS report.

Create a Report Server project as in Figure 1.

Figure 1: Report Server Project

Add a data source as in Figures 2 and 3.

Figure 2:
Configure DataSource

Figure 3:
Choose appropriate Stored Procedure

Add a New Report Item as in Figure 4.

Figure 4:
Add Report

Insert a table as in Figure 5.

Figure 5:
Insert table

Figure 6:
Choose datasource and create a query

Figure 7:
Design View

Figure 8:
Add table for employee report

Figure 9:
Choose datasource and create a query

Figure 10:
Design View

Figure 11:
Report Parameter Properties

Figure 12:
Dataset properties

Figure 13:
Text Box Properties

Figure 14:
Text Box properties

The output of the report is as in Figures 15 and 16.

Figure 15:
Output employee report

Figure 16:
Output department report


In this article we saw how to use linked reports for a SSRS report.