To create a master-detail report

To create a master-detail report

Master-detail reports use related information that is stored in another feature class.

1. In AutoCAD Map 3D toolset, click Enterprise and open a project
2. Select the Industry Model node.
3. Click Industry Model menu > Report Designer.
4. Open the report.
5. In the right pane, click the Detail Body 1 section.
6. Click Add menu > Child Group.

   The child group with Head 1.1, Body 1.1, and Foot 1.1 is inserted between the Detail Body 1 and Detail Foot 1 sections.

7. In the right pane, select the Detail Body 1.1 section.
8. In the left pane, in the Group:Detail property grid, select the SQL property to define the SQL statement. Click and enter the following statement:

   select * from ...
   

   where ... = {Id}
   

   At runtime, the application replaces the value {Id} with the value of the column ID from the record in the parent group.

9. Click Add menu > DB Column. Select the columns to print.

   You can select several items (multi selection) by pressing and holding <SHIFT> or <CTRL>.

10. Click the Detail Head 1.1 section.
11. Click Add menu > Text. Add the text controls for the caption.
12. Click Report menu > Save.
13. Click the Preview tab. Each master display model followed by the detail definitions and colors is displayed in the report.

For more information about master-detail forms refer to TB_RELATIONS: Master-Detail Relations.