Display Every three rows has diffrent color repeatedly using tablex report in ssrs

• viveksvkola

  SSCrazy

  Points: 2229

  More actions

  March 29, 2013 at 4:58 am

  #275695

  Hi All,

  I have one requirement like report display 25000,client want to display

  row1=green,

  row2=blue,

  row3=red,

  row4=green,

  row5=blue,

  row6=red,

  row7=green.........

  can any one give me how to resolve the issue with details.

  Thanks,

  Vivekanand Kola

• deepkt

  SSC Eights!

  Points: 951

  More actions

  March 29, 2013 at 6:13 am

  #1601982

  Try this:

  In the Report maintain a new column with Id, like it is an serial number , You can do this Using ROW_NUMBER() OVER (Order BY column)

  And in your report select the entire Row which has values., go to Properties

  And Under color , Update Black with

  =Switch((Fields!RowID.Value MOD 3) = 1,"Green",(Fields!RowID.Value MOD 3) = 2,"Red",(Fields!RowID.Value MOD 3) = 0,"Blue")