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)=&