none
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
    Monday, June 01, 2009 2:30 AM

Answers

All replies

  • 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~~
    • Proposed as answer by Stone.Hao Monday, June 01, 2009 8:12 AM
    • Proposed as answer by Stone.Hao Monday, June 01, 2009 8:12 AM
    • Unproposed as answer by GurunGuns Monday, June 01, 2009 9:50 PM
    • Proposed as answer by richw23 Friday, October 15, 2010 10:10 PM
    Monday, June 01, 2009 3:38 AM
  • 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.
    Monday, June 01, 2009 5:46 PM
  • 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

    Tuesday, June 02, 2009 2:35 AM
  • it's a little self-serving to mark your own posts as "answer", isn't it?
    Thursday, May 03, 2012 10:05 PM