Hi what is sub report where we use the sub reports..give me screen shots...N.suresh

A subreport is a report that is called in another report.MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

Hi Suresh, A report within another report is a sub report, i.e. there will be two reports one is master(which will call that sub report) and another one is child. The child report or sub report can accept parameter(s) from the master report & will execute its work.Basically we use the sub report where we want to show big template on a report, then we divide that report into sub report(s) and then call those sub reports into main report, let me know if you need any further clarificationThanks, Sumit

Not SSIS related, try the SSRS forum: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads or google: http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx http://www.youtube.com/watch?v=k_V4lam_5I0Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Hi Suresh, A subreport is a report item that displays another report inside the body of a main report. Conceptually, a subreport in a report is similar to a frame in a Web page. It is used to embed a report within a report. Here has a MSDN article abtou subreport that might helpful for you, and there is a screenshot in it, please see: http://msdn.microsoft.com/en-us/library/dd239314.aspx If you have anything unclear, please feel free to ask. Charlie LiaoCharlie Liao TechNet Community Support