Dynamic Formatting in reporting services
Second time again I have been caught in performing the dynamic formatting, though this is more kind of development type of question and I was searching through Reporting Services side. The issue is to change/highlight the color of a row, base on its value, in case if a column value is say greater that 90%, the cell should be red.
You can achieve this by performing under Reporting Services by choosing the color property of the field:
=iif(Fields!MyField.Value > 85, "Red", "Black")
Also here's a good link for this kind of stuff http://msdn2.microsoft.com/en-us/library/ms156400.aspx
