CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2ssrs-2012ssrs-tablix
KCodeR
KCodeR

Reputation: 139

Alternate Row Colour SSRS not working

i currently have the row background colour set with expression that is;

=IIF(ROWNUMBER(NOTHING) MOD 2,"White","Silver")

However on some rows it seems that colour is not alternating and staying the same like the image below. Does any one know why this may be happening

image of alternating rows

Upvotes: 0

Views: 1981

Answers (1)

StevenWhite
StevenWhite

Reputation: 6024

The expression itself is fine, it's the scope that's the problem. The ROWNUMBER function gives different results based on which groups it's in within your matrix. You are currently using Nothing as the argument which tells it to use the default scope. You will need to look into overriding that with the correct group name so that the row numbers are calculated relative to the scope you actually want.

Upvotes: 1

Related Questions