widsnet.com
8Oct/150

Make a row red in Report Builder

This is a quick code snip to color a row red in Report builder based on the value in a field. In this case when the ExitCode isn't 0. I use it when checking the OS Installation Status of a Task Sequence. This code also keeps all the other rows colored the default way, gray/white.

=Switch(Fields!ExitCode.Value <> 0, "Tomato",
RowNumber(Nothing) Mod 2 = 0, "Transparent",
RowNumber(Nothing) Mod 2 = 1, "Gainsboro")
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.