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:

  1. Define the ORDER BY clause. For more information, go to Edit the query for a business record.
  2. Open the reports .4rdj file.
  3. Within the central workspace, click on the relation element between the two records. For more information on the relation element, go to Relation.
  4. In the Properties window, click the run dropdown list, and select one of the following:
    • BEFORE
    • ON EVERY ROW
    • AFTER
  5. 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.