Hi Guys,

i have a little Problem.
In  my report i have a group {items.row}

Now i need to color every second item of every single group, like this:
Group 1
item 1 - crGrey
item 2 - crNoColor
item 3 - crGrey

Group 2
item 1 - crGrey
item 2 - crNoColor

Group 3
item 1 - crGrey
item 2 - crNoColor
item 3 - crGrey
item 4 - crNoColor

So every group must start new with coloring the items.

Can anybody help me?

many thanks
Mike

Hi manjucrystal,

thanks for the tip.
I already tested this and doesn't work at all - don't know why.


I solved it now with the database:
ROW_NUMBER() OVER (PARTITION BY "row_name" ORDER BY "row_name" ASC) AS GroupRank
So you get for each item of  group a new rank like:

Group 1
item 1 - rank (1)
item 2 - rank (2)
item 3 - rank (3)

Group 2
item 1 - rank (1)
item 2 - rank (2)

Now I can work with the same if-condition like yours :)
if (Remainder ({items.GroupRank}, 2) = 0)
then
crNoColor
else
Color (212,212,212)

But many thanks for your help :D


Edited by Stang67 - 08 Nov 2013 at 4:59am

Hi DBlank,

I've tried your version and it works exactly like my db-version :D

Many thanks for this tip - for the next time i have two solutions :)