Conditional Formatting In Sharepoint

Hello all,
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.


Cheers


GiracAsked:
Who is Participating?
 
georgekhalilConnect With a Mentor Commented:
You can utilise the inbuilt DVWP available via SharePoint Designer to achieve this...

http://www.endusersharepoint.com/2009/11/02/comparing-dates-in-a-data-view-web-part-to-build-a-wss-kpi-in-sharepoint/
0
 
Ted BouskillSenior Software DeveloperCommented:
@georgekhalil: The Data View Web Part and the Data Form Web Part are the same thing.  The user is already using it.

Conditional formatting is achieved using custom XSLT which is demonstrated in this article:
http://sanjayapdl.wordpress.com/2009/07/19/customizing-a-sharepoint-data-form-web-part/

Generally all data in Sharepoint is rendered using XML which can be customized using XSLT when displayed on the page.
0
 
georgekhalilCommented:
@tedbilly, sorry my bad, intention wasn't to repeat what the author had stated, however I was merely pointing to the EUSP article that goes in some depth on what is possible in integrating colored indicators as required by the author.
0
All Courses

From novice to tech pro — start learning today.