CODEWITHSUNDEEP
ssrs-2008
Stephan Rieber
Stephan Rieber

Reputation: 35

Assign a color to individual row numbers

I am trying to assign an individual color to each row in a group. There are approximately 50 rows I need to assign a color and they all must be unique. What would be the easiest way to do this?

I do not want to do the alternating row colors:

"=IIf(RowNumber("DataSet1")  Mod 2 = 1, "White","Blue")",

but if there was a way to modify this expression to do 50 colors and then repeat I'd be okay with that.

Upvotes: 0

Views: 88

Answers (1)

Ezhil Arasan
Ezhil Arasan

Reputation: 478

you can use choose . otherwise use custom code function

=Choose(ROWNUMBER(nothing) mod 50,  "Brown", "Blue",  "GoldenRod", "Olive", "MediumTurquoise","Red", "Green", "DeepSkyBlue", "Yellow", "Chocolate", "Purple", "DarkOrange" ,.....)

Upvotes: 1

Related Questions