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.
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.
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.
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.
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.
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.1206.641
The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...Microvellum Foundation Library Release Notes | Build 24.1127
The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...Toolbox Release Notes | Build 24.1.1125.641
The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...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 ...