Microsoft Office® Access 2007 Inside Out

Creating and Embedding a Subreport

In many of your reports, you will probably design the Detail section to display a single line of information from the underlying record source. As you learned earlier in this chapter, it’s fairly easy to link several tables to get lots of detail across several one-to-many relationships in your database. You also saw how to use the Hide Duplicates property to display a hierarchy across several rows of detail.

However, as with forms and subforms, which you learned about in Chapter 13, you can embed subreports (or subforms) in the Detail section of your report to display multiple detail lines from a table or query that has a many relationship to the one current line printed in the Detail section. You must use this ...