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 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 ...
    • 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 ...
    • 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 ...
    • Tutorial: Creating a Report with a Sub Report in Report Designer

      The articles in this section of the Knowledge Base involve working with Sub Reports for display in your reports. To learn more about Sub Reports, and how to access this section within the Report Designer, see Understanding Sub Reports in Report ...
    • Recent Articles

    • Microvellum Foundation Library Release Notes | Build 22.0729

      The following release notes apply to Microvellum Foundation Library, Build 22.0729 Note: This build (22.0729) contains the necessary requirements to support the new Microvellum "Library Update Utility". If your library version is older than 22.0729, ...
    • Toolbox Release Notes | Build 22.1.0720.641

      The following Release Notes apply to Toolbox Build 22.1.0720.641 Processing Stations Resolutions: Resolved an issue with the saw file output for Ardis processing stations when you have “None” set as the picture type. Resolved a refresh issue when ...
    • Toolbox Release Notes | Build 22.1.0712.641

      The following Release Notes apply to Toolbox Build 22.1.0712.641 Workbook Designer Resolutions: Resolved an issue with Part Properties updating the wrong 2D Plan Token workbook cells. Resolved an issue with saving formula materials through Workbook ...
    • Microvellum Foundation Library Release Notes | Build 22.0625

      The following release notes apply to Microvellum Foundation Library, Build 22.0625 Additions: Added Access Panel Subassembly (from legacy component library) Added the prompts "Extend Left Side To Floor" and "Extend Right Side To Floor" to all ...
    • Asking to Re-Activate Software on Start Up

      If your license is current, but you keep getting the Activate Software window when starting up Toolbox, this is the fix. Instead of entering your serial number and password every time, go to your MV Toolbox icon on your desktop and Right-click then ...