CODEWITHSUNDEEP
reporting-servicesreport
ChiSen
ChiSen

Reputation: 373

Dynamic background color formatting in SSRS 2008

I am currently working on a report in which the columns are dynamic. Now my boss wants to have a pattern on table header like below.

color pattern

But my columns are dynamic. I have tried using =RowNumber(nothing) mod 7 = n , but i never got the right combination. Please help. Thanks in advance

enter image description here

Upvotes: 1

Views: 344

Answers (1)

Mahesh
Mahesh

Reputation: 8892

If you want to show the column color depending on its count and you are doing the column grouping then 

 = IIF (CountDistinct(Fields!FieldUsedAsColumnGrouping.Value,"DatasetName") Mod 7 = 0,"grey color","some other color")

Hope this helps..In case of issue comment.

Upvotes: 1

Related Questions