.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to display/calculate total of a custom column in dataview webpart's grouping header

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :SharePoint


I've created a dataview from a MOSS2007 form library. In the dataview, I've enabled grouping by a specific column and also was able to show the total (sum) of couple of columns like this, in the group heading:

<xsl:value-of select=”sum($nodeset/@Total_x0020_Cost)” />

So far, it's working fine. I've added couple more columns to this dataview. There's a piece of javascript code that is executed for each row. These 2 columns gets their value from this javascript. Now, is there anyway, I can get the total/sum of these columns in the group heading.

Have you done something like this? Please advise.




View Complete Post

More Related Resource Links

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

Dataview Webpart - display document type icon with status

Hello, I recently came across an excellent post by Marc Anderson on how to surface the document icon within a DVWP. http://sympmarc.com/2008/09/10/displaying-the-document-type-icon-in-a-dvwp-in-sharepoint/ What I wanted to know is has anyone any knowledge of how to extend this so that the icon will reflect if a document is checked out? Thank you for your comments and thoughts. Sincerely, Tim

Display total sum in another column

Hi All, I need one help... my source is having column1... column1:    2    3    4    5 Sum=14 I need a query to display my output like this... column1  totalSum    2           14    3           14    4           14    5           14 Thanks in Advance, RH    sql

Html column with ListaData.svc + linq + custom webpart

Hello Everybody, 

I'm developing a custom web site with sharepoint, so, I have one custom list that has a html column type. 
I'd like to get this column with linq and ListData.svc, on my custom webpart. But, when I called the method, it's not return this column.

So, my question is:  Can I get a Html column by listdata.svc ?


remove Column header from List View Webpart


hi, i am having sharepoint 2010 Enterprise RTM trial on Windows server 2008 SP2. I wanted to know how a column header of a list in List View Webpart can be hide ?

i have tried the following article:


but i don't see any source editor in content Editor Weppart and also the Hidden button is disabled....

Is it necessary to do this task from code ?

Display rating control in xslt list view webpart without table header



In the same code, pasted above if I want to display rating control using xslt list view webpart what I need to write.

I have created few xslt list view webparts for my site but I am not able to display rating control using xslt. I am writing something like this

<xsl:apply-templates select="$Fields[@Name='AverageRating']" mode="PrintField">
              <xsl:with-param name="thisNode" select="."/>
              <xsl:with-param name="Position" select="$Position"/>

But for this I think i need to include some parameter or any particular template. Using the above type of code in xslt this is not working. I do not want to display table header row. Please guide me on this.


Custom comments display webpart for Blog



I wrote a custom webpart to display the comments made on any post of blog (eg: <blog>/List/Posts/Post.aspx?ID=3)

Now two things:

1. Comments list does not have any post-Id, It has post-title with Lookup type. which stores complete title of post which this comment blongs to. While in URL i am getting Post ID. How may i filter the comments ? 

2. How may i check that if logged in user has Admin rights ? Because I want to display "Edit" with each comment if logged in user has Admin rights.

Thanks in advance.

How to calculate the total of wpf datagrid text column



I have WPF DataGrid that is bound to and entity.

The DataGrid has a "Difference" column that is computed from the difference between two other columns in the same DataGrid.

Now I have a TextBox outside the data grid that should contain Sum of all cells in the "Difference" column.

How do I do that?


<DataGrid AutoGenerateColumns="False" HorizontalAlignment="Stretch" Margin="5,35,150,40" Name="BoxCountDataGrid" VerticalAlignment="Stretch" ItemsSource="{Binding UpdateSourceTrigger=PropertyChanged, Path=DemersalBoxCounts}" >


                              <DataGridTextColumn.HeaderTemplate >
                    <TextBlock Text="Recorded Box Unit/Weight(kg)" Width="70" TextWrapping="Wrap"/>

              <DataGridTextColumn Binding="{Binding DEBC_BCT}" Width="*">
                <DataGridTextColumn.HeaderTemplate >
                    <TextBlock Text="Box Count" Width="70" TextWrapping="Wr

Matrix Column grouping - Total column incorrect when colum value is wrapped in a call to code


I have a column grouped matrix report that shows count, cost and duration.  Duration is time in seconds.  To format the time on the report as hh:mm:ss I send it through a code block that converts the int to a string. 

When the report is generated the total column is NOT code.convert(sum(Fields!Duration.Value)).  At first I thought it was taking the max value, then I thought it is was taking the first value.. not really sure how it is calculating the value.

I did trying wrapping the expression like this IIF(InScope("matrixgroup"), Code.Convert(Fields!Duration.Value), Code.Convert(Sum(Fields!Duration.Value))).  It didn't make a difference the column is still incorrect.

If I remove the Code.Convert from the column, the value is correct.

Does anyone have any suggestions?



Needing a Total based on a dynamic total in a column grouping


Hi, Please help

I am using RS2008
I have a Tablix with a row grouping by Location and a row field Totalling the current employee count for that state

I have three adjacent columns grouping by Month, based on what month is selected in the multivalue-parameter, one column returns back number of employees joined for those months. second column how many left for those month. The third column the total headcount for those months

FOR Example if the parameter selected was Jan, Feb, March, the below would be returned

                                 JOIN                   LEFT                  HEADCOUNT
     CURRENT      Jan  Feb March         Jan Feb March         Jan Feb March 
WA     15              2    3    4        &nbs

Custom Display in Data View column in SharePoint



I am using SharePoint designer 2007 to create Data View web part where I want custom display text in one column depending upon condition. In designer there is way to implement custom display which allows to change style conditionally. Is there any way to change the text conditionally?

Just to underline the problem I want to change text in Data View column conditionally.



Display column from child table. Possible ?



I'am using dnamic entity with EF4. On a list page of a table, I would like to display a column containing information from a child table of the current element. Sample :

Order List :

Order Data | Required Date | Shipped Date | etc... | ... | Customer Name (foreign key with tostring() method override) | Customer Postal Code (Column that I want to add) |

I don't known how to do that. Is it possible ? Maybe I have to to create my own Metadata proxy that will add dynamicly a column on the MetaColumn list of the table.

Does someone have an easier or better idea ?

Thank you for any help.

How to read the custom http header



I have just joined the forum. I have a very simple query. I have added custom header to my website. Now I want to read the custom header. I am using IIS 6.0 on windows XP. I have already tried using using the Request.ServerVariables and and Request.header method. But none of them give me the custom header added to website.

Can any body help?

Thanks a lot in advance



SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services


SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.

James Yip

MSDN Magazine February 2005

DataGrid: Tailor Your DataGrid Apps Using Table Style and Custom Column Style Objects


One of the most enduring challenges in writing user interfaces is figuring out how to display large amounts of data efficiently and intuitively without bewildering the user. The problem becomes particularly thorny when the interface must reflect hierarchical relationships within the data that the user needs to modify. The Windows Forms DataGrid control gives developers a powerful and flexible tool to meet this challenge. This article explains its basic operations and shows how to extend the DataGrid to display columns of data in an application-appropriate manner.

Kristy Saunders

MSDN Magazine August 2003

Custom Grid View Header - Grid view Row Created event vs Gridview row databound events ?


Hi Gurus ,

It happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .

Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically  behaviour of both the events in !Postback and page.Postback .

Thanks a tonne in Advance and  any inputs will be valued and appreciated .

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend