Master-Detail Reports with Detail Report Bands

If you have data with parent and child records, like invoices and their line items, this tutorial guides you to leverage those through nested Detail Report bands to create master-detail reports. This is perfect for visualizing hierarchical data structures when your data source has a master-detail relationship.

1. Get started: Create a new layout or open an existing one.

2. Drag the data fields you need from the Field List to the *Detail* area.

3. Right-click on the canvas and select Insert Band--> Detail Report to add a detail report band to the report.

   

4. With your Detail Report band selected, find the Data Member property in the properties pane. In the Data Member drop-down list, choose the name of the master-detail relationship that establishes the link between this band and the broader report data.

   

   To select multiple fields, hold down the CTRL key and click on each desired field individually. Alternatively, you can hold down the SHIFT key to select a range of consecutive fields as well.

   

   For a detailed report, drag fields from the category that matches to your master-detail relationship. This ensures your report displays all the relevant data. Otherwise, you might only see the first record from the detail table repeated for each master record.

   Customize the visual style (fonts, colours, etc.) and formatting of data values (e.g., currency symbols, percentages) in your report as required.

Refer to the following example to understand how the design & preview of the layout works in the master-detail report:

• Design :

  

• Executed Report :