Sub Report using SSRS


This article shows how to use a sub-report for a SSRS report.

Create a Report Server project as in Figure 1.


Figure 1: Report server project

Add a report as in Figures 2 and 3.


Figure 2: Add new item


Figure 3: Employee report

Insert a table as in Figure 4.


Figure 4: Add table

Set the shared datasource properties as in Figure 5.


Figure 5: Add datasource

Choose a data source and create a query for employeedataset as in Figure 6.


Figure 6: Choose datasource

Choose a data source and create a query for departmentdataset as in Figure 7.


Figure 7: Select stored procedure

Create a Department report as in Figure 8.


Figure 8: Add department report

Create Employeedataset as in Figure 9.


Figure 9: Employee dataset

Insert a row, an insert group below as in Figure 10.


Figure 10: Insert row - inside group below

Create a parameter for the Department dataset as in Figure 11.


Figure 11: Department dataset

Add a parameter for department as in Figure 12.


Figure 12: Add parameter

Add deptId as in Figure 13.


Figure 13: Parameter properties 

Add departmentId filter as in Figure 14.


Figure 14: Add filter

Add a subreport as in Figure 15.


Figure 15: Select subreport

Set the sub-report properties as in Figure 16.


Figure 16: Department report as subreport

Set the sub-report parameters as in Figure 17.


Figure 17: Add parameter

Figure 18 shows The Output of the basic sub-report.


Figure 18: Output


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

Similar Articles
MVC Corporation
MVC Corporation is consulting and IT services based company.