Nesting Groups in Report Designer

Nesting Groups in Report Designer

The articles in this section of the Knowledge Base involve working with Groups for display in reports. To learn more about Groups and how to access the Report Designer, see Understanding Groups in the Report Designer. This article explains the process of Nesting Groups.

Report Designer allows for the nesting of groups. For example, Subassemblies can be grouped by material and then sub-grouped by width. To achieve this style of report, place the required number of Group Header bands before the Data band and ideally, the same number of Group Footer bands immediately after it:


Fig. 01 – Nest Group Bands

It is recommended that there is always an equal number of Group Header and Group Footer bands on a report to avoid unexpected results. When the number of Group Footer bands is greater than the number of Group Header bands, then the outer ones are used, and the inner bands are ignored. When the number of Group Footer bands is less than the number of Group Header bands, then the Group Header bands placed closer to the Data band are output without footers.

In Figure 01, GroupFooterBand2 is left empty. It acts like a Child band, leaving an empty data row separating material groups.

Grouping criteria must be specified for each Group Header band. When rendering the report, the Group Header bands are processed in the order in which they appear on a page, working from the top down. The topmost band is processed first, then the one that is placed directly underneath it, and so on. When placing Group Footer bands on a report page, it is important to remember than the last Group Footer band is always associated with the first Group Header band.


Fig. 02 – Nested Group Report Example
    • Related Articles

    • Using the Group Footer Band in Report Designer

      The articles in this section of the Knowledge Base involve working with Groups for display in reports. To learn more about Groups and how to access the Report Designer, see Understanding Groups in the Report Designer. This article regards working ...
    • Understanding Groups in the Report Designer

      The articles in this section of the Knowledge Base involve working with Groups 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 ...
    • Using Render Events on Group Header Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Groups for display in reports. To learn more about Groups and how to access the Report Designer, see Understanding Groups in the Report Designer. This article details Events in ...
    • Using Group Properties in Report Designer

      The articles in this section of the Knowledge Base involve working with Groups for display in reports. To learn more about Groups and how to access the Report Designer, see Understanding Groups in the Report Designer. This article details properties ...
    • Adding a Footer to a Table in 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 information on ...
    • 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 ...