SQL Server Performance Forum – Threads Archive
Adding cell color depending on value of field ??Can anyone tell me how one could change the color of a cell in my matrix report depending on the value of a cell ? ie: if the value of the field is less than 10, i want the cell color to be red, or over 10 , and it should be green .. If not, anyone know of any resources out there yet where I could find out this info ?? thanks so much !
In the Properties for the cell colour select <Expression> and in the Expression Editor enter something like
=iif(Sum(Fields!FieldName.Value)< 10, "Red", "Green")
where FieldName is the name of the field in question. HTH Jasper Smith
perfect, thanks a ton.
Question, is it true that Expression is pretty much the only way to manipulate report objects(Textbox, Lines, Rectangle, Image)? Thanks in advance.
Pretty much, yes. You can add your own functions etc from the Code tab or custom assemblies but you can only really use them where you see <Expression> HTH Jasper Smith
Thanks for the info!!
quote:Originally posted by jasper_smith Pretty much, yes. You can add your own functions etc from the Code tab or custom assemblies but you can only really use them where you see <Expression> HTH Jasper Smith