Multi band column sum | Infragistics Forums

885

Multi band column sum

Leonid posted over 15 years ago

Hi,

Following code works fine but for single band grid only, however my grid will have 3 bands. Any sample how to sum single column values across all bands in grid?

Thanks!

With Me.Grid1.DisplayLayout.Bands(0)

Dim summarySetting As SummarySettings = .Summaries.Add(SummaryType.Sum, Nothing, .Columns(1), SummaryPosition.UseSummaryPositionColumn, Nothing)

summarySetting.DisplayFormat = "${0:#,###}"

summarySetting.Appearance.FontData.Bold = DefaultableBoolean.True

summarySetting.Appearance.TextHAlign = HAlign.Right

End With

885

Leonid posted over 15 years ago in reply to Mike Saltzman

Do you mean I will have to present to users unbound columns and hide real one?
Cancel
Reply

Cancel
469350

Offline Mike Saltzman posted over 15 years ago
There's no way to sum three different bands in one operation.
What I would do is this:
On the last band, you create a summary to sum a column.
On the parent of that band, you add an unbound column.
Use the InitializeRow event to populate this unbound column with the summary from the child rows.
Then you can add a summary to the unbound column and do the same thing on the parent of this band.
To get the child row summary value, you would do something like this in InitializeRow:
e.Row.ChildBands[0].Rows.SummaryValues["My Summary"].Value
Cancel
Reply

Cancel
3186

Offline Nick Smith posted over 15 years ago

Don't believe there is any way to do that across bands. You could perhaps flatten your datasource into one band and perhaps use GroupBy's to simulate multiple bands and accomplish the summaries that way.

Nick

PS: Here is a message from Mike that perhaps may help http://forums.infragistics.com/forums/t/19857.aspx
Cancel
Reply

Cancel