Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Ashok
1284
Win Grid - Sum of all the values in a column
posted

Hi

i am using ultra win grid 8.0  in my VB.NET windows application. I have a column which displays the integer values.
I am populating the grid on click of a button.

I want to display the sum of all the values in a column in the last row of that column.  The sum should be calculated dynamically whenever the values in the Grid changes  .

Is there any property or Formula to calculate the sum of all the values in a column ?

Thanks in Advance.

 

Ashok

Parents
No Data
Reply
  • 2334
    Verified Answer
    posted

    Yes, add a Summary to the Summaries collection of the appropriate band.  For example,

    ultraGrid1.DisplayLayout.Bankds(0).Summaries.Add(SummaryType.Sum, col, SummaryPosition.Blah, Nothing)

     You have control as to where the summaries are displayed and how they are formatted.  By default a sum will display as "Sum = 12345".

Children