SSRS Report Linked Reports

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.