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).
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.
Switch to the Field List, select the data fields while holding down CTRL or SHIFT and drag-and-drop them onto the Detail band.
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.
Switch to Print Preview to see the resulting report.