Having trouble having the color of the text change based on the value in Report Builder 2.0. The expression being used is: =Iif(Fields!Work_Item_Count.Value >= 10, "Red" , "Black") For some reason not all values greater than or equal to 10 are changing to red. The screen shot provided gives an idea of what is actually being produced. Anything other than the totals that are greater than 10 should be red.

Is this a matrix report? If yes you might want to consider using a SUM() in the Expression.Regards, Ritta Singh

Hi, By initial glance it looks like, the actual formula used to display the values are not the same as Fields!Work_Item_Count.Value. Try changing expression to =Iif(sum(Fields!Work_Item_Count.Value) >= 10, "Red" , "Black") - Chintak (My Blog)

adding 'sum' to the expression worked. Copied the original code from http://msdn.microsoft.com/en-us/library/dd283099(v=sql.100).aspx Looks like they left that out. Thanks Chhapia Chintak Chhapia Synaptic Digital MCC 10,855 Points1632 Recent Achievements Forums Answerer IVCode Answerer IIIProfile Complete Chintak Chhapia's threadsView Profile