COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Cognos_Jan2017 on 06 Jul 2018 02:29:07 PM

Title: Highlight List Alternate Rows Utilizing Two(2) Colors
Post by: Cognos_Jan2017 on 06 Jul 2018 02:29:07 PM
In a List, we select all columns, then assign an Advanced Conditional Style using ...
1 - Advanced Conditional Style 1 ...
     mod(RowNumber(),2) = 1
     Background Color = White
2 - Advanced Conditional Style 2 ...
     mod(RowNumber(),2) = 0
     Background Color = Lime

That works fine, except for a Column which is a Repeater.
We can understand how a Repeater can have different RowNumbers combining entries.

Is there a way to handle this?

TIA, Bob
Title: Re: Highlight List Alternate Rows Utilizing Two(2) Colors
Post by: Cognos_Jan2017 on 06 Jul 2018 03:07:00 PM
Even tried different Advanced Conditional Styles of ...
1 - Advanced Conditional Style 1 ...
     Column [TheCount] = mod(Running-Count([DueInDays]),2)
     Background Color = White
2 - Advanced Conditional Style 2 ...
     Column [TheCount] = mod(Running-Count([DueInDays]),2)
     Background Color = Lime

[TheCount} results in either 1 or 0.  This also works except for the Column which is a Repeater.

Am thinking we either don't alternate row color for this Report, or IF we do when there is a
Repeater Column, that we accept its limitations.

As in my first Post, Is there a way to handle this?

TIA, Bob
Title: Re: Highlight List Alternate Rows Utilizing Two(2) Colors
Post by: Cognos_Jan2017 on 06 Jul 2018 03:24:21 PM
Removing the Advanced Conditional Style, from the Repeater Column, ensures
the color for that Column is the Default White ... maybe the best thing to do.

Still open to suggestions.

TIA, Bob