How can I show a summary in the footer of a win grid and not have the Sigma show up in the header?

sum infragistics ultrawingrid
BCarpe picture BCarpe · May 3, 2012 · Viewed 7.7k times · Source

I'm using an Infragistics UltraWinGrid and would like to be able to display the sum of several columns. I got that working by allowing row summaries. However, I only want them to be able to see the sum, not have all these other crazy options that come along with that little sigma in the header. How can I get rid of this while keeping the sums at the bottom?

Answer

Steve picture Steve · May 3, 2012

You should have the DisplayLayout.Override.AllowRowSummaries property set in this way:

DisplayLayout.Override.AllowRowSummaries = AllowRowSummaries.Default;

then use code like this to create your summary (Need to check before creating another summary with the same name)

private void BuildCurrencySummary(string name, UltraGridColumn col)
{
    SummarySettings ss = grd.DisplayLayout.Bands[0].Summaries.Add(name, SummaryType.Sum, col);
    ss.SummaryPositionColumn = col;
    ss.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
    ss.Appearance.FontData.Bold = Infragistics.Win.DefaultableBoolean.True;
    ss.Appearance.ForeColor = Color.Black;
    ss.Appearance.TextHAlign = HAlign.Right;
    ss.DisplayFormat = "{0:C}";
}

Related questions

Sum a list of numbers in Python

I have a list of numbers such as [1,2,3,4,5...], and I want to calculate (1+2)/2 and for the second, (2+3)/2 and the third, (3+4)/2, and so on. How can I do that? I would like to sum the first number with the second and …

Read More
How do you find the sum of all the numbers in an array in Java?

I'm having a problem finding the sum of all of the integers in an array in Java. I cannot find any useful method in the Math class for this.

Read More
Sum function in VBA

I have a problem with summing cells in vba. I need to use Cells(a,b): Range("A1").function="=SUM(Range(Cells(2,1),Cells(3,2)))" but it doesn't work.

Read More