This topic will guide you through the process of creating a master-detail report with dbForge Studio for MySQL.
Note that it is recommended that you review the How To: Create a Simple Data-Aware Report topic first. It will help you learn how to bind report to data with dbForge Studio.
Make the master table active by right-clicking the table name in the Data Source window and selecting Set Active Item on the shortcut menu:
Note that in the Data Source tree the fk_customer_address node should be available. If it is not, refresh data in the Data Source tree by clicking the Refresh Data button on the Data Source toolbar.
Right-click your report in the document area to invoke its shortcut menu. In this menu, point to Insert Detail Report and click fk_customer_address option to add a new detail report. Detail Report band will appear:
Right-click the detail report to invoke its shortcut menu, point to Insert Band and click Group Header. This will add the GroupHeaderBand to the detail report:
You can add the Label control to the added GroupHeader band and change text in it to Customer details:.
Also drag the label with the Phone text in it and the one bound to the phone data field to the Detail band of the detail report to show the phone number as detailed information on customer.
In this topic you’ve created a master-detail report.