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)
summarySetting.DisplayFormat = "${0:#,###}"
summarySetting.Appearance.FontData.Bold = DefaultableBoolean.True
summarySetting.Appearance.TextHAlign = HAlign.Right
End With
Do you mean I will have to present to users unbound columns and hide real one?
There's no way to sum three different bands in one operation.
What I would do is this:
To get the child row summary value, you would do something like this in InitializeRow:
e.Row.ChildBands[0].Rows.SummaryValues["My Summary"].Value
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