[FAQ's: OD] How do I add a Sub Report to a Report?
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.
Next, you can choose the source for your subreport. For this example I am using a report I already created.
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.
Choose to keep the name for your SubReport or rename it if you want and click Finish.
Now you will see your SubReport on your main report as shown in Fig. 5. Make any necessay modifications and Preview the report.
Preview of finished report displaying a nested SubReport with its own set of related records.
Last edited by RobDog888; Jul 10th, 2006 at 12:58 PM.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.