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 24.1.0409.641

      The following release notes apply to Toolbox build 24.1.0409.641 Saw Delimited Processing Station Figure 1: The Saw Delimited option in a custom processing station. New options have been added to saw processing stations to allow for control over data ...

    • Toolbox Release Notes | Build 24.1.0328.641

      The following release notes apply to Toolbox Build 24.1.0328.641 Fillet Token Fixes Issues were discovered in the use of fillet tokens on products that also had the IRIB setting enabled: Some users processed work orders with rounded parts, which ...

    • Microvellum Foundation Library Release Notes | Build 24.0322

      Additions Added the Master Angled Ends Cabinet. Added a Global prompt, "Hinge Plate Offset From Front" for easier control. Added “Double Division” option to Horizontal Designer Cabinets, 3 Door Cabinets, and other similar products. Added a new ...

    • Common Floating License Connectivity Issues

      This document lists common issues reported by users regarding the topic of Microvellum’s Floating License Activation (FLA) and the connectivity required for FLA to function. Firewall Blocking Activation of Floating License Some users have had an ...

    • Toolbox Release Notes | Build 24.1.0318.641

      The following release notes apply to Toolbox build 24.1.0318.641 Shadowline Fix Figure 1: Shadowline shaping issue (left) and fixed (right). There were reports of users experiencing issues with products having incorrectly shaped shadow lines when the ...