We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Perform operations on columns using GridSummaryRowDescriptor

Thread ID:





82274 Jun 8,2009 02:03 PM UTC Jun 9,2009 11:46 AM UTC WinForms 1
Tags: GridControl
Administrator [Syncfusion]
Asked On June 8, 2009 02:03 PM UTC

I'm summarizing a grid with 5 columns. For most columns, I simply take the sum of the values for that particular column. But there are some columns that need division operations for the summary. To illustrate:
Column 1- summary of column 1
Column 2 - summary of column 2
Column 3 - Summary of column 1/ summary of column 2
Column 4 - Summary of Column 4
Column 5 - ((Summary of Column 1 *4 ) + Summary of Column 2)/ 100

It's simple enough to format the sum of each column, but how do you format the summary row of column 3 and column 5? (Both Column 3 and 5 should come out in 2 decimal places e.g. .05)

I am using this syntax for column 1, 2 and 4:
Dim sd1 As GridSummaryRowDescriptor = New GridSummaryRowDescriptor(.Name, Syncfusion.Grouping.SummaryType.Int32Aggregate, .Name, "{Sum:#,##0}")


Lingaraj S [Syncfusion]
Replied On June 9, 2009 11:46 AM UTC

Hi Karver,

Thank you for your interest in Syncfusion product.

If you want to calculate the summary row value depends on the another summary column value. It can be achieved through some workaround with QueryCellStyleInfo event. Please try using the TableCellIdentity.SummaryColumn and VisibleColumns property in QueryCellStyleInfo event to achieve this behavior. The Summary Column used to placed the calculated value into summary cells.

Refer the sample in below link:

This sample demonstrate your requirements with GridGroupingControl summaries.

Let me know if you have any queries.

Lingaraj S.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon