I have a view in SQL showing as a dataFormWebPart, with a few fields, Sales, Number of Sales.
I would like to add a red/green/yellow indicator in a column if these fields are greater that a trigger point, also a field in my view.
It would go something like this: If(@30daySales>@30DayTrigger then GreenIcon, Else If(@30daySales>@30DayTrigger1 then YellowIcon Else If(@30daySales<@30DayTrigger then redIcon.
Also, Would I have to upload these images in an Image Library or are they included in SP?
I ran across the how-to before but cannot find it now. Any help would be great.