Summary-Detail Report (Detail Report Bands)

To create a summary-detail report (report with hierarchically linked data) using the Detail Report band, follow these steps.

• Bind the report to a data source containing a data relationship.

  

  To do this, on the Reports Wizard's last page, select the data tables.

  

  If it is possible to link these tables (e.g. by the common key field). The relations section is displayed in the Field List.

• To add a Detail Report band, right-click the Report Designer, and in the displayed Context Menu, point to Insert Detail Report. If the bound data source contains a data relationship, the submenu will contain an item with the name of that relationship. Select this item to create a Detail Report band, already bound to the detail table.

  

• Drop the required data fields from the Field List onto the report's Detail and Detail Report bands.

  Regarding the Detail Report band, note that only items from the relation section (in this example it is the Categories Products section) should be dropped, or there will be incorrect output in the report.

  

The summary-detail report is now complete. Switch to the Preview tab to view the result.