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

    • Toolbox Release Notes | Build 25.1.0213.641

      The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...

    • Toolbox Release Notes: Year of 2024

      This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...

    • Toolbox Release Notes | Build 25.1.0129.641

      The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...

    • Microvellum Foundation Library Release Notes | Build 25.0124

      The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...

    • SQL Server Backups

      This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...