Attach a master-detail to BEFORE/AFTER groups
Within a ReportData .4rdj file, the run and group property of the relation allows you to attach a master-detail to BEFORE/AFTER groups defined by the OrderBy of the parent record.
By default, master-details are attached ON EVERY ROW. To attach a master-detail to BEFORE/AFTER groups:
- Define the ORDER BY clause. For more information, go to Edit the query for a business record.
- Open the reports .4rdj file.
- Within the central workspace, click on the
relation
element between the two records. For more information on therelation
element, go to Relation. - In the Properties window, click the run dropdown
list, and select one of the following:
- BEFORE
- ON EVERY ROW
- AFTER
- In the
relation
properties, click the group dropdown list and select the group to apply the run property to.
Rebuild and execute the application. The master-detail has been attached the group specified in the Properties.