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.1206.641

      The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...

    • Microvellum Foundation Library Release Notes | Build 24.1127

      The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...

    • Toolbox Release Notes | Build 24.1.1125.641

      The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...

    • 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 ...