Reporting Services – Background coloring

August 25th, 2008 by Mr.M | No Comments »

if you need to color code the background of a row based on the values stored in 2 or more columns, use the following code:

=iif(field!cloneStatus.Value = 1 AND field!dbStatus.value = 1, "orangered", "white")

This line of code basically states that if the cloneStatus and dbStatus doesn’t contain the value of 1, then set it to OrangeRed, else keep it at White.

Leave a Reply

You must be logged in to post a comment.