[FAQ's: OD] How do I add a Sub Report to a Report?

[RobDog888]

There are several ways to add one report to another report creating a report within a report (sub report). You can use the SubReport Wizard (Fig.1) to add a report to another report as a nested subreport.

Select the SubReport control from the Controls Toolbox and draw your report by left clicking and dragging the mouse for the size and location for your subreport. Then release the left mouse button when done and the Wizard will popup like in fig. 2.

Fig. 1
http://www.vbforums.com/attachment.php?attachmentid=47502





Next, you can choose the source for your subreport. For this example I am using a report I already created.

Fig. 2
http://www.vbforums.com/attachment.php?attachmentid=47503




After selecting to use my "Report4" I select to choose the fields that will link the two reports records together in a hierarchal order. Then click Next.

Fig. 3
http://www.vbforums.com/attachment.php?attachmentid=47504




Choose to keep the name for your SubReport or rename it if you want and click Finish.

Fig. 4
http://www.vbforums.com/attachment.php?attachmentid=47505




Now you will see your SubReport on your main report as shown in Fig. 5. Make any necessay modifications and Preview the report.
Fig. 5
http://www.vbforums.com/attachment.php?attachmentid=47506




Preview of finished report displaying a nested SubReport with its own set of related records.

Fig. 6
http://vbforums.com/attachment.php?attachmentid=49262