Posts

Showing posts from October, 2012
XSL Data View Web Parts are very powerful ways to view and manipulate SharePoint list data.  Here are some good resources I have found:

http://sympmarc.com/  specifically his unlocking of the XSL transforms in DVWP.  In fact his information is so good I purchased his $25 72-page pdf on XSL.  Worth the investment.

Go here to purchase your own: http://sympmarc.com/2010/04/28/unlocking-the-mysteries-of-the-sharepoint-data-view-web-part-xsl-tags-ebook-now-available/

Here is a great concept on the use of XSL as templates across your site(s):
http://sympmarc.com/2010/05/28/the-spxslt-codeplex-project-new-xsl-templates/

Here are the CodePlex XSL templates: http://spxslt.codeplex.com/documentation

XSL Dashboard

Previously I had some issues trying to display SharePoint List data as rollups using a DataView Web Part (DVWP).  The problem I had is in remembering how to do a count of a query for every row that satisfies a condition, like a status or category.

The trick is creating variables and then calling the variables later, which really helps in creating percentages.

These 2 variables are default with every DVWP:
  <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row"/>
  <xsl:variable name="dvt_RowCount" select="count($Rows)"/>
You can call the total number of items in a list like this:
  <xsl:value-of select="$dvt_RowCount"/>

Here is an example of a way to show the number of items in a list split up by status.  Status is a drop-down choice column with 3 values: (Input, In Progress, Complete)

<xsl:variable name="InputCount" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status)='Input'…