Create a Master-Detail Report (Use Detail Report Bands)

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 Create a Master-Detail Report (Use Subreports).

1. Create a new report or open an existing one.

2. Bind the report to a required data source and provide it with a master-detail relationship as described in the Bind a Report to a Database topic.

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

   

4. 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.

   

5. 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.

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

Switch to Print Preview to see the resulting report.