A subreport is a complete report that is placed in another report. If you've got one item that is linked to several items in another table, such as a department and its employees, then a subreport is what you need. In such cases, generally, the main report (where the subreport is placed) contains the data of the master/parent table, and the subreport contains the data of the detail/child table. For example, one department has many employees, where
Department is the master/parent table and
Employee is the detail/child table. In our database, a particular
Sale has many
salesLine entries. If we want to show the details of a particular
Sale, then in the main report, we will show
SalesNo, SalesDate, and
CustomerNo; and in the ...