How to highlight the rows sequentially with different colour & it should repeat

[inu]

HI guys,
I have a report with hundreds of records. I want to highlight first 3 rows with red colour, second 3 rows with blue color, third 3 rows with green color. On further, for other rows, again it should repeat from the first ('red'), then second ('blue') and so on untill the end of the records.'

Is it possible to develop this report .

Please share the ideas!!!!!!!!!!!!!!!!!!

Cheers !
Inam

[MFGF]

HI guys,
I have a report with hundreds of records. I want to highlight first 3 rows with red colour, second 3 rows with blue color, third 3 rows with green color. On further, for other rows, again it should repeat from the first ('red'), then second ('blue') and so on untill the end of the records.'

Is it possible to develop this report .

Please share the ideas!!!!!!!!!!!!!!!!!!

Cheers !
Inam

Hi,

Add a query calculation with the expression

mod(floor((running-count ([a unique data item for each row]) -1) / 3),3)

You can then define a conditional highlight based on the results

Cheers!

MF.

[inu]

Hi MF,
Thanks a lot, u r great

cheers !
inam