Creating a Master-Detail Report in Report Designer

Creating a Master-Detail Report in Report Designer

The articles in this section of the Knowledge Base involve working with and creating Master Detail Lists for display in reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report from scratch or New Report from Existing. Select Designer to open Report Designer.

It is sometimes necessary to create reports and render data that is organized in some levels and connected. For example, Products and Subassemblies are connected in that Subasssemblies make up Products. In this case, Master-Detail reports are used. Master-Detail reports are reports in which the value of the Master data source corresponds to the number of values (from 0 and greater) from the Detail data source. Figure 01 features an example of a Master-Detail report.


Fig. 01 – Master-Detail Report Example

As demonstrated in Figure 01, each Product corresponds to the list of Subassemblies for that Product. Figure 02 features an example of the report template that generates this report.


Fig. 02 – Master-Detail Report Template Example

The data displayed in the detail section of a Master-Detail report is nested data. The data is nested into one data row of the Master data source. The amount of nesting is called the level of nesting. If two lists are output in the Master-Detail report, and the second list is connected to the first, then this example has two levels of nesting, the first being the Master and the second the Detail.

There is no limit to the level of nesting.

Master-Detail Report Tutorial

To create a Master-Detail report, place two data bands on a page in the report template. Assign the Master data source (Products) to the first band, and assign the Detail data source (Subassemblies) to the second data band.

The data bands need to be connected, or two full lists will be printed, one after the other. The data bands are bound using the Master Component property of the second band. The Master band should be assigned as the Master Component for the second band.

The Master Component can be assigned through the property or directly through the Data Band Editor window.


Fig. 03 – Master Component Property of the Detail Data Band


Fig. 04 – Master Component Tab of the Detail Data Band Editor Window

After the Master Component has been assigned, the two bands are bound to each other. When one row of the Master band is printed, all of the rows of the Detail band are output, repeatedly. To fix this, so that detailed data is selected only for the specific Master band row, a Relation is used.

A Relation is created using the Data Relation property of the Detail band, or the Relation tab of the Detail Band’s Data Editor Window.


Fig. 05 – Data Relation Property of the Detail Data Band


Fig. 06 – Relation Tab of the Detail Data Band Editor Window

Learn More about Creating a Relation

Once the Master Component property and the Relation have been established, the report is ready to be rendered and should resemble Figure 01.


    • Related Articles

    • Understanding Multi Level Nesting in Report Designer

      The articles in this section of the Knowledge Base involve working with Master-Detail lists for display in reports. To learn more about Master-Detail Reports and how to access the Report Designer, see Creating a Master-Detail Report in Report ...
    • Understanding Row Numbering in Master-Detail Reports

      The articles in this section of the Knowledge Base involve working with Master-Detail lists for display in reports. To learn more about Master-Detail Reports and how to access the Report Designer, see Creating a Master-Detail Report in Report ...
    • Report Training Tutorial 4: Creating Master Detail Reports

      This is the fourth in a series of five Report Training Tutorial videos.  This video provides an introduction to Master Detail Reports including the required  Database Structure and Table Relations.  You'll learn how to create your own Master Detail ...
    • Creating Lists in Report Designer

      The articles in this section of the Knowledge Base involve working with Lists for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report from ...
    • Output Lists with Report Designer

      The articles in this section of the Knowledge Base involve working with Lists for display in your reports. To learn more about Lists and how to access the Report Designer, see Creating Lists in Report Designer. This article provides additional ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.1105.641

      The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...
    • Microvellum Foundation Library Release Notes | Build 24.1025

      The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...
    • Toolbox Release Notes | Build 24.1.1030.641

      The following release notes apply to Toolbox build 24.1.1030.641 Routing and Profile Fixes Several issues were found with routing and polyline paths: Fig. 1: Horizontal routes off of a part disappearing (left) and appearing correctly (right). When ...
    • Toolbox Release Notes | Build 24.1.1010.641

      The following release notes apply to Toolbox build 24.1.1010.641 Biesse Winstore Fix Several issues with the Biesse Winstore plugin have been resolved: There was an issue that would sometimes occur wherein materials that were intended to stack wound ...
    • Toolbox Release Notes | Build 24.1.1001.641

      The following release notes apply to Toolbox build 24.1.1001.641 HBore Toolfile Fix Fig. 1: The location in the Toolfile UI where the error would occur. There was an issue reported with the functionality of the Horizontal Boring Machine setting in ...