SSRS – Creating a subreport and managing multiple subreports and linking them – Part 5
SSRS – Creating a subreport and managing multiple subreports and linking them and passing parameters between them.
This article explains the basic steps of creating a subreport and managing multiple reports and linking them and passing parameters between them.
SSRS – Creating a subreport and managing multiple subreports and linking them and passing parameters between them – Part 5
This article explains the basic steps of creating a subreport and managing multiple reports and linking them and passing parameters between them.
Open SQL Server Business Intelligence Management Studio
Create a MainReport.rdl
(Note: If you not familiar to create report, find the previous sections)
Fill in the Connection Properties Window
Write the query which you want to display in Data tab
Design the MainReport as like following picture
After designing, click the preview
Add another report names SubReport and do the same steps as we have done above.
When writing a query we have to mention where condition because we should receive parameter value from the mainreport
Design the subreport
Click preview
In this time, it asks parameter value in a textbox (contID which have mentioned in query)
Fill the textbox and click view report
Creating reports (mainreport and subreport ) are overLinking Reports
Now we should link the reports
Go to Layout of MainReport
Right click of the field in which you should connect with another report
Select properties
Click Navigation tab in Properties Window
Select jump to report
Select the subreport in that dropdown list box
Click Parameters button and select Parameter Name and Parameter Value Which we have to pass value to subreport
Ok
Click Preview
Save and Run the Project
Screen looks like below picture
When we drag over the mouse in ContactID fields, Mouse Icon should be changed
If you click here in contacted field, it shows subreport for the corresponding contacted value
If you want to return back to mainreport, click the icon which is mentioned Back to Parent Report like below picture.
Conclusion
Do the all steps and enjoy linking reports.
Reference: http://www.dotnetspider.com/resources/42873-SSRS-SQL-Server-Reporting-Services-Create.aspx
Follow
Still now i have not used any Matrix Report.
If i aware, let you know or post article about this soon.