Skip to content
  • There are no suggestions because the search field is empty.

How to Configure Alternating Row Colors for Line Items in a Report

Styles let you quickly apply your company's branding to reports. By default, every line-item row uses the same style, but many organizations prefer alternating row colors to improve readability and make individual line items easier to distinguish. This article describes how to configure alternating row colors for line items in your reports.

Create a New Style

Use the following procedure to create a new style for alternating rows. The example in this procedure creates a light grey background for alternating rows.

For more information about styles, see, Change Fonts and Colors in Your Report With the Styles Editor.

  1. Open an estimate in DESTINI Cloud: Estimator.
  2. Navigate to Home > New Report. Report Designer opens.
  3. Click File > Open.
  4. Navigate to the folder with the report template file (.repx) you want to modify.
  5. Click the .repx file to open it.
  6. On the right side of your screen, at the bottom of Report Explorer, verify the Report Explorer tab is selected.
  7. Right-click Styles and then select Edit Styles. Styles Editor opens.
  8. In the left pane, click CostItemDetails.
  9. Click the Clone a style button () in the top left corner of the window.
  10. With the new style selected, enter CostItemDetails_Alternating in the Name field.
  11. Click the Background Color option and choose a gray (or silver) color.
  12. Click Close.

      Change the Report Design

      Use the following procedure to apply the light gray style to alternating line-item rows.

      1. Locate the Search box at the top of Report Explorer on the right side of your screen.
      2. Search for Details_LineItems and click the result.
      3. In Designer in the middle of your screen, click the GroupHeader band that prints line-item information (GroupHeader10 in the Owners report).
        Note: For the LMSEO report, select the first table row (TableRow15) inside the group header.
      4. With the GroupHeader band selected, click the Function button on the right.
      5. On the left side of the Expression Editor window, click Style Name.
      6. Inside the text box in the top middle of the window, paste the following and click OK.
        Iif(GroupIndex(0) % 2 = 0, 'CostItemDetails', 'CostItemDetails_Alternating')



        Note: If you prefer to switch the row colors, you can use the following expression so odd rows in the grouping use a light grey background and even rows use a white background.

        Iif(GroupIndex(0) % 2 = 1, 'CostItemDetails', 'CostItemDetails_Alternating')

      7. Save and run the report.