To total a column of values in a Sharepoint DVWP use: To do something similar in Xpath with formatting:
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
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 … Continue reading DVWP How to remove duplicate entries in filter dropdown list
If you try & display rich html columns or any other columns that uses HTML in a DVWP/CQWP 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 … Continue reading How to display HTML in the Dataview & Content Query Webpart (DVWP CQWP)
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 … Continue reading How to make the filter choices display by default in the DVWP
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.