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
885
Multi band column sum
posted

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