Adding Alternating Rows to Lists in Report Designer

Adding Alternating Rows to Lists 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 highlighting alternating rows to improve the appearance of your reports.

Report Designer offers two ways to alternate row colors in a table:

  1. Highlight Conditions
  2. Data Band Styles

Using Highlight Conditions

Open an existing report that has a list in which you wish to alternate row colors.


Fig. 01 – Simple List without Alternating Rows

In Figure 01, all rows have the same background color. With the Data band selected, double-click the Conditions property to open the Conditions Editor.


Fig. 02 – Conditions Property

From the Conditions Editor, select Add Condition > Highlight Condition.


Fig. 03 – Highlight Condition

To alternate row colors, add an expression that sets the condition so that every ODD row has the properties applied. Enter the following expression:

(Line And 1) = 1

Fig. 04 – Condition Editor

Choose the Properties you wish to be applied to every odd row. Render the report, and it should look something like Figure 05.


Fig. 05 – Alternating Row Colors

Using Data Band Styles

The second method of alternating row colors is to utilize the Odd Style and Even Style properties. This method allows you to create your own styles and choose which ones are applied to which rows, odd or even.


Fig. 06 – Odd and Even Style

Styles allow for additional customization of rows. With one Style applied to odd rows, and a different Style applied to an even row, the report looks something like the following:


Fig. 07 – Alternating Rows using Styles
    • Related Articles

    • 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 ...
    • Creating Multiple Lists 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 for ...
    • Understanding Empty Data Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Empty Data bands 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 ...
    • Using Render Events on Data Bands 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 ...
    • 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

    • Microvellum Foundation Library Release Notes | Build 26.0220

      The following release notes apply to the Microvellum Foundation Library build 26.0220. Additions Added DTC Magic Pro and Magic Star Ultra drawer systems. Magic Pro Items added in hardware file 300 and 600 lengths for all drawer heights. Add 60kg ...
    • Microvellum Release Notes | Build 25.2.0223.641

      The following release notes apply to Microvellum build 25.2.0223.641. Add 2D Elevation Tokens to 3D Drawings Fig. 1: The new 2D Elevation setting. A popularly requested feature by the community has been added to the Microvellum software: the checkbox ...
    • Microvellum Processing Center Application

      The standalone Processing Center application provides shop-floor tools for managing and executing manufacturing data generated from Microvellum projects. It enables users to: Print part labels View and print reports Create and re-create manufacturing ...
    • Microvellum Release Notes | Build 25.2.0213.641

      The following release notes apply to Microvellum build 25.2.0213.641 File Name Fix An issue was occurring when processing work orders with the Create Sequential File Names setting enabled. When the setting was enabled, a work order being processed ...
    • Microvellum Release Notes | Build 25.2.0206.641

      The following release notes apply to Microvellum build 25.2.0206.641. Item Number Fix An issue was reported regarding item numbers in composite drawings. Users who processed work orders with multiple products reported that the item numbers would ...