Introduction
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
Summary
In this article we saw how to use linked reports for a SSRS report.