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
Quote from: inu on 03 Aug 2014 08:07:31 AM
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.