Skip to main content
Sign In |
  Help (new window)
Sympraxis Consulting

Demos

Go Search
Home
Services
Clients
About
Contact
  

View All Site Content

Sympraxis Consulting > Demos > Demo Pages > DVWPCalcHTMLColumn

 Sales Opportunities
TitlePotential ValueColorColorHTMLConverted ColorHTML
Mon Jul 26 2010 20:12:46 GMT-0400 (Eastern Daylight Time)-434.00Red<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:red;'>✹</span></span>✹✹✹
Come visit SharePointDevWiki.com58.11Amber<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:RGB(255, 191, 0);'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
Come visit www.sharepointdesigners.net529.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
Me New Zealand529.00Red<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:red;'>✹</span></span>✹✹✹
Markup director aide de campe529.00Red<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:red;'>✹</span></span>✹✹✹
Excelente Funcionalidad235.00Red<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:red;'>✹</span></span>✹✹✹
Ben's Web Shack542.00Amber<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:RGB(255, 191, 0);'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
Rosslyn, VA Demo User -- Checking out cascading dropdowns149.00Red<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:red;'>✹</span></span>✹✹✹
Jewelry by Irina 209.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
Big Whoppin Humongous Deal!103.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
test2.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
test010.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
test020.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
gn0.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
fdg0.00Amber<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:RGB(255, 191, 0);'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
hkjk0.00Green<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:green;'>✹</span><span style='padding:-10px;color:gray;'>✹</span><span style='padding:-10px;color:gray;'>✹</span></span>✹✹✹
 

 DVWP Calculated HTML Column

Thie page shows a technique developed by Christophe Humbert which he calls the HTML Calculated Column. Christophe asked me some questions about how to go about "unescaping" HTML in a Data View Web Part (DVWP), and this is the page which resulted.

The ColorHTML column is a calculated column which contains the formula:
="<span style='background-color:black;font-size:24px;'><span style='padding:-10px;color:"&IF(Color="Green","green;'>✹","gray;'>✹")&"</span><span style='padding:-10px;color:"&IF(Color="Amber","RGB(255, 191, 0);'>✹","gray;'>✹")&"</span><span style='padding:-10px;color:"&IF(Color="Red","red;'>✹","gray;'>✹")&"</span></span>"

  • You can see the XSL for the DVWP here.