Monday, June 01, 2009 2:30 AMHi, 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.
Monday, June 01, 2009 3:38 AM1. 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.
~~ Mark it as Answer if you find it correct~~
Monday, June 01, 2009 5:46 PMThanks 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.
Tuesday, June 02, 2009 2:35 AMModerator
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:
Also, I think maybe you don’t need subreoprt, just take a look at the sample of Reporting Services, include the download link:
Hope this helps.
- Marked As Answer by Raymond-LeeMicrosoft Employee, Moderator Friday, June 12, 2009 5:15 AM
Thursday, May 03, 2012 10:05 PMit's a little self-serving to mark your own posts as "answer", isn't it?