Creating Multi-Column Reports in Report Designer

Creating Multi-Column Reports in Report Designer

The articles in this section of the Knowledge Base involve working with Columns 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 scratch or New Report from Existing. Select Designer to open Report Designer.

For particularly long reports, it is sometimes preferable to shorten the length by splitting the Data Band or Page up into multiple columns. The Report Designer supports two types of columns, Columns on a Page and Columns on a Data Band.

Columns on a Page

The Columns property of the Report Template page is used for outputting data in columns. This property is set to 0 by default. Changing the value to two or more will cause the data to be output in columns. The Column Gaps and Column Width properties will also need to be set.


Fig. 01 – Columns Properties

The Column Width property is used to determine the width of the columns. The width entered here is applied to all of the columns. The Column Gaps property specifies the width of the space between the columns.


Fig. 02 – Column Width and Column Gaps

  1. Column 1’s Width
  2. Column 2’s Width
  3. The Gap’s Width

In columnar output mode, the Page is separated vertically, and the Report is logically output in the first column, then in the second, and so on.

An unlimited number of columns can be inserted within a page.

When the Report Template from Figure 02 is rendered, it produces the following Report:


Fig. 03 – Example Multi-Column Report

The columns are generated automatically. Report Designer prints Data Rows until there is no free space left on a page. Instead of creating a new page, a new column is added, and data is output in that new Column until there is no free space. If there is still data to be output after a page is filled, a new page is created, and the process starts over.

Columns on a Data Band

The one disadvantage to columns is when the situation arises where there is sufficient data to fill only one Column, leaving the other columns empty and that part of the Page unused. To get around this problem, use Data Bands to output columns instead of using the Page.

To enable the display of data in columns, use the Columns property of the Data Band. As with Columns on a Page, set the Columns property to two or more to create a columnar format for the Report.

The Column Width and Column Gaps properties need to be set as well.


Fig. 04 – Columns Properties for a Data Band

The Column Direction property is covered in another article.

Setting up the Report Template with Columns on a Data Band results in something similar to Figure 05.


Fig. 05 – Report Template – Columns on a Data Band

In Figure 05, a Column Header Band is used in place of a traditional Header Band. Like the traditional Header Band, this band will automatically replicate the Column Headers above both columns. Despite this Band spreading across the Page, unlike the traditional Header Band, you do not need to copy the Column Headers over manually.

When the report is rendered, it should look something like Figure 06.


Fig. 06 – Multi-Column Report using Columns on Data Bands

Note the difference between using Columns on a Page versus Columns on a Data Band. The Columns on a Data Band method leads to two evenly spaced columns with space at the bottom of the Page, as opposed to the empty space being in the column on the right. This method leads to a much more uniform Report.

    • Related Articles

    • Using the Column Direction Property for Multi-Column Lists in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in multi-column reports. To learn more about Columns and how to access the Report Designer, see Creating Multi-Column Reports in Report Designer. This article ...
    • Using the Column Header Band in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in multi-column reports. To learn more about Columns and how to access the Report Designer, see Creating Multi-Column Reports in Report Designer. This article ...
    • Using the Column Footer Band in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in multi-column reports. To learn more about Columns and how to access the Report Designer, see Creating Multi-Column Reports in Report Designer. This article ...
    • Using the Min Rows in Column Property in Report Designer

      The articles in this section of the Knowledge Base involve working with Columns for display in multi-column reports. To learn more about Columns and how to access the Report Designer, see Creating Multi-Column Reports in Report Designer. This article ...
    • 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 ...
    • 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 ...