Master-Detail
Last updated
Was this helpful?
Last updated
Was this helpful?
Create a new ReportTemplate and save it as order-detail.ozr.
Add a Data band named master.
Add a FixedTable (4 by 7)
Data row height = 0.3 inch, line spacing = 0.1 inch
Lines for Address and Due date: use Cell Merge and Cell Divide
Put field titles.
Assign dataset field values from the dataset order.
Add a Data band named detail below the order band.
Add a Table component as illustrated below.
Master Band settings
Right-click the detail data band to open the Master Band Settings dialog.
Select master<order> as Master band.
Select the SalesOrderID and click the Connected button (or connect by dragging).
Tick the Sort detail data by master data
Set the Force New Page property to True.
Set the Fix Master property to True.
Set the Fix Title property to True.
