Alternate Row Color

2 posts, 0 answers
  1. Eric Klein
    Eric Klein avatar
    183 posts
    Member since:
    Aug 2009

    Posted 13 Feb 2013 Link to this post


    When I try to alternate row color on a table on a report I use the Conditional Formatting =RowNumber()%2

    When the report runs I get the error “Aggregate node ‘LeafNumber(Const(RowNumber))’ not found.

  2. José Miguel Herrera G
    José Miguel Herrera G avatar
    2 posts
    Member since:
    Nov 2019

    Posted 06 Nov in reply to Eric Klein Link to this post

    After searching and searching because RowNumber() is returning always 1, I managed it by adding the next ConditionalFormatting rule:

    "= RunningValue("table1",Sum(1)) Mod 2"  "<>"  "0"

    as shown in the attached screenshot.

    Finally select a different style for that rule.

    I hope it this will help you :)

    Regards from Colombia, José Miguel.

Back to Top