Subreports in SSRS?

Question

Hi, well I want to implement Subreport in my SSRS reports. Can anyone suggest few good links which can guide me how to use the SSRS subreport feature.

Thanks

---

Thanks!! MCP

Answer 1

1. Create Report 1 , this is your main report.
2. Create Report 2 , this will act as subreport.
3. Now open report 1 and from toolbox drag the subreport control to this main report.
4. Then Right click on the subreport control and configure it to Point to the Report 2.
5. Configure the Parameter For subreport , if you have to pass any paramter.

Also you can refer to these article.
http://msdn.microsoft.com/en-us/library/ms159837.aspx
http://msdn.microsoft.com/en-us/library/ms160348.aspx

---

~~ Mark it as Answer if you find it correct~~

Answer 2

Thanks for the steps.
How the end report will look like?
Actually I have Excel report with different sheets and in an effort to replicate it in SSRS I am looking for some alternate solution in SSRS, I thought subreport can help me in that.

Answer 3

Hi,

 

You can follow the above steps to create a report with subreport. The end report just like a normal report, one difference is if you are using single report, you can only use one dataset in a data control. But if you drag a subreport into a report, there are two different dataset in one data control, it will be more flexible. Also, it’s easier to create a report with complicated design. Here is a step by step document:

http://www.codeproject.com/KB/reporting-services/ReportingServices.aspx

 

Also, I think maybe you don’t need subreoprt, just take a look at the sample of Reporting Services, include the download link:

http://msdn.microsoft.com/en-us/library/ms160954.aspx  (2008)

http://msdn.microsoft.com/en-us/library/ms160954(SQL.90).aspx (2005)

 

Hope this helps.

Raymond

Answer 4

it's a little self-serving to mark your own posts as "answer", isn't it?