To total a column of values in a Sharepoint DVWP use:

<xsl:value-of select="sum(/dsQueryResponse/Rows/Row/@TotalHoursWorked)" />

To do something similar in Xpath with formatting:

format-number(sum(/dsQueryResponse/Rows/Row/@TotalHoursWorked), '#,##0.00;-#,##0.00')

A useful tool to encode and decode your Sharepoint CAML queries.

Use the CAML encoder and decoder to encode or decode CAML while working with SharePoint Data Source Control queries. This script utilizes both HTML rendering to decode and a PHP function to encode.

Sharepoint CAML query Encoder & Decoder

More From pstilgoe

• Enhanced Content Query Web Part
• Sharepoint and JQuery
• Sharepoint 2010: How to hide the quick launch menu

Ask pstilgoe To Recommend Your Posts

When displaying the filter bar in a data view webpart it will list multiple instances of the same option if the data exists multiple times in your datasource ie. say you have a 100 list items & one of the columns contains a ‘yes’ or ‘no’, it will list them 100 times instead of just a single ‘yes’ / ‘no’ option to apply on your filter.

To remove duplicate filter options, open your dataview webpart in Sharepoint Designer & look for:

<br /> <xsl:for-each select="msxsl:node-set($dvt_Rows)/*[not(@*[name()=$dvt_FieldNameNoAtSign]=preceding-sibling::*[1]/@*[name()=$dvt_FieldNameNoAtSign])]/@*[name()=$dvt_FieldNameNoAtSign]">

Simply remove the ‘[1]‘ from each filter option, now your filter dropdowns will only display unique values, removing the duplicate options.

If you try & display rich html columns or any other columns that uses HTML in a DVWP it will display as the actual HTML as opposed to outputting it as HTML formatted text.

If you added your data using Sharepoint designer “Insert Selected Fields” you need view your DVWP code in SPD & search for:

xsl:value-of select=”@MyHTMLFormattedColumn”

and replace it with

xsl:value-of disable-output-escaping=”yes” select=”@MyHTMLFormattedColumn”

Now your data in this column will display as you expected ie. formatted with the HTML code applied.

Note: In SPD 2010 you will need to convert your DVWP to XSLT, On the ribbon:

List View Tools –> Design –> Customize XSLT

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• View PDF documents in a webpart
• How to make the filter choices display by default in the DVWP

Ask pstilgoe To Recommend Your Posts

When configuring your DVWP in SPD you can choose to enable filter options, however you have to click the filter button in order to display the filter options. If you want the filter options to display by default when you open the page with the DVWP all you need to do is to remove the following line from the DVWP webpart code:

<xsl:if test="$dvt_adhocmode = 'filter'" ddwrt:cf_ignore="1">

Below this line of code you will see all the filter fields that you can filter data on by default, if you want to limit what you users can filter on you can just remove the various lines of code for each filter.

More From pstilgoe

• How to Prevent users from changing views in Sharepoint
• How to delete the Shared Service Provider in MOSS 2007
• Sharepoint 2010: How to hide the quick launch menu

Ask pstilgoe To Recommend Your Posts

If you are getting the error:

‘An error occurred processing the data view. The XslText property is empty’

You have probably inserted an extra dataview on your page, check your page & remove the extra data view you accidentally inserted & your error will go away.

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• Error: There is no file with URL ‘http://test-url’ in this Web.
• Error: Cannot retrieve the information for application credential key

Ask pstilgoe To Recommend Your Posts