I am trying to put a rag colour to text using the expression builder The RAG colours are the standard RED - AMBER -GREEN except the condtions to each are 2
For example A figure is between 70% and 75% and the code for this is P
I can manage to get this to work with the condition being between the percentage but not if it also meets the code P criteria.
Any assistance in mulitple conditions would be great
So, you have tried something like:
=iif((fields!figure.value >= 70) and (fields!figure.value <= 75) and (fields!code.value = "P"), "Red", iif(etc...
I have expressions like this working in several of my reports. Hope that helps! Let me know if you are receiving an error or if nothing seems to be happening.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?