Create a Multi-Column Report

• Dec 23, 2019
• 3 minutes to read

This document describes how to arrange report data in multiple columns, which can be used to create mailing labels, business cards or multi-column directories.

Introduction

The following images illustrate different multi-column report layouts.

Down Then Across

Across Then Down

As opposed to side-by-side reports that are mainly used to display content from different data sources, multi-column reports enable you to arrange content from a single data source.

To quickly create labels of standard sizes, you can also use the Label Wizard.

For a corresponding online demo, see Multi-Column Report.

Settings

To access the multi-column settings of a report’s Detail band, use its smart tag or the Properties window.

The DetailBand.MultiColumn property provides access to the following multi-column settings of the Detail band.

Setting	Description
MultiColumn.Mode	Enables you to select one of the following modes. MultiColumnMode.None Disables the multi-column layout. MultiColumnMode.UseColumnCount Makes the report display a specific number of columns based on the MultiColumn.ColumnCount value. When this property is set to 1, the report looks as though its multi-column layout is disabled. MultiColumnMode.UseColumnWidth Makes the report columns have a specific width based on the MultiColumn.ColumnWidth value. With this setting, the report displays as many columns as it is possible according to the specified column width, column spacing and report page size.
MultiColumn.ColumnSpacing	Specifies the distance between adjacent columns. This value is measured in report units.
MultiColumn.Layout	Specifies the preferred direction for arranging report data within columns. ColumnLayout.AcrossThenDown The report data is arranged horizontally and is wrapped to the next row on reaching the right page margin. When the report data is grouped, the multi-column layout is applied to each group individually. ColumnLayout.DownThenAcross The report data is arranged vertically and is wrapped to the next column on reaching the bottom page margin. When the report data is grouped, group bands serve as column headers or footers. Set the Group Footer band’s PageBreak property to AfterBand to make each group start on a new column.

How It Works

The following image illustrates a report designer with a multi-column layout applied to the report.

In multi-column mode, the report’s design surface is limited to the area defined by the column width. This is the only area intended to contain report controls.

The rest of this surface defines the space on a page remaining for printing columns and column spacing area.

In the above image, the report data in the Detail band is contained within a Panel that provides borders around the enclosed content.

You can also specify a custom background color for the Panel. To learn how to change this color dynamically (based on the report’s underlying data), see Conditionally Change a Control’s Appearance.

When the report data is grouped (as in the above image), and the down-then-across multi-column layout is used, you can make each group start on a new column. To do this, set the Band.PageBreak property of the Group Footer to PageBreak.AfterBand or PageBreak.AfterBandExceptLastEntry. When there is no data to display in the Group Footer, set the band height to zero.