Last, but not least, we create a report using a subreport. It should do more or less the same as the report in the previous section. Create a new report based on the 'authors' table and a new field in the datasection depending on the 'name' column.

We are now going to change the datasection properties. Click on the header of the datasection and then click on the "Subreport" button in the "Data" tab. The subreportdialog will be displayed.

Figure 7.5. The subreport window

Set the report we created first, "literaturereport", as the subreport. Remember that this report is based on the 'literature' table. The "literaturereport" (the subreport) should show only the literature of the authors shown in the main report. So set the fields as shown in the figure above.

Using the 'before sectiondata' checkbox, you can control whether the subreport is printed before or after the data of the main report section.