Let's say you have created different reports and now you would like to call one or more than one of them in new report(Main Report). You can use Sub Report Item in SSRS To call any report.
So Sub Reports are just like other reports and we can call them by using SubReport Item in other Report ( Main report).
Step 1:
To Call existing report (SubReport), You can to bring SubReport Item in your Main report as shown below.
How to use SubReport Item in SSRS Report - SSRS Interview Questions and Answers
Step 2:
Right click on SubReport Item and go to properties as shown below
Step 3:
Choose the report you would like to call in your main report.
So Sub Reports are just like other reports and we can call them by using SubReport Item in other Report ( Main report).
Step 1:
To Call existing report (SubReport), You can to bring SubReport Item in your Main report as shown below.
Step 2:
Right click on SubReport Item and go to properties as shown below
How to call a report in Main report in SSRS - SQL Server Reporting Services
Step 3:
Choose the report you would like to call in your main report.
How to use SubReport Item in SSRS to call another Report - SQL Sever Reporting Services
If you are passing value of a field to sub report Parameter, go to Parameters tab and map the field to Parameter.
In my case subreport has parameter Region and I mapped to Region field from Main Report.
How to map parameter for Sub Report from Main Report in SSRS Report - SSRS Tutorial
No comments:
Post a Comment