• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Working with Reports > Adding a Subreport to a Report

Adding a Subreport to a Report

You can use a wizard to quickly create a report that is bound to the information in one table or in several related tables. However, reports often include multiple sets of information that are related to the topic of the report but that are not necessarily related to each other. A report might, for example, include charts, spreadsheets, and other forms of information about several divisions or activities of a company. Or it might include information about production, marketing, sales, compensation, and the company’s 401(k) plan. All these topics are related to running the business, but they don’t all fit nicely into the structure of a single Access report.


One solution to this problem is to create separate reports, print them, and put them in one binder. An easier solution is to use subreports. A subreport is simply a report that you insert in another report. You create the subreport as you would any other report, and then use a wizard to insert it. You can also use a wizard to insert a subreport control in the main report, and then let the wizard guide you through the process of creating the subreport in the control. In either case, you end up with both the main report and the subreport listed as objects in the Reports pane of the database window.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint