Adding cell color depending on value of field ?? | SQL Server Performance Forums

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

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |