This is a migrated thread and some comments may be shown as answers.

Alternate Row Color

1 Answer 260 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Eric Klein
Top achievements
Rank 1
Eric Klein asked on 13 Feb 2013, 03:16 PM

 

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.

1 Answer, 1 is accepted

Sort by
0
José Miguel Herrera G
Top achievements
Rank 1
answered on 07 Nov 2019, 02:40 AM

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.

Tags
General Discussions
Asked by
Eric Klein
Top achievements
Rank 1
Answers by
José Miguel Herrera G
Top achievements
Rank 1
Share this question
or