This tutorial illustrates how to display hierarchical data in a master-detail report using nested Detail Report bands. This approach is effective if your data source contains master-detail relationship. Another way is described at Master-Detail Reports with Subreports.

 

1.Drop the required data fields from the Field List onto the Detail band.

2.Create a Detail Report Band by right-clicking the report's surface. In the invoked context menu, select Insert Detail Report, and then, select the master-detail relationship's name.

This sets the detail report's Data Source and Data Member properties automatically.

3.Switch to the Field List, select the data fields while holding down CTRL or SHIFT and drag-and-drop them onto the Detail band.

Note

You should drag-and-drop fields from the category corresponding to the master-detail relationship to correctly generate the detail report's data. Otherwise, the report will display only the first record of the detail table as many times as there are records in this table.

4.If required, customize the report's appearance and format values.

Switch to Print Preview to see the resulting report.