Thursday, October 9, 2008

Conditional Background color for Text box

1.  Background color based on the value of the input parameter
 
        =iif(Fields!TextBox1.Value = Parameters!ParameterName.Label,"LightGrey","DarkGrey")  1.  Background color based on the value of the input parameter

2.   Background color based on a condition

       =iif(Fields!TextBox1.Value > 10,"LightGrey","DarkGrey")

3.   Background color on alternating row

       =iif(RunningValue(Fields!FieldName1.Value,COUNTDISTINCT,NOTHING) MOD 2 = 0,"LightGrey","DarkGrey")