This will be comma separated list of formats where you can specify a string format for 1 or more calculators as needed.
Example: ”sum: TOTAL={0:c}, average: AVG={0:c}, count: COUNT={0}”
Each comma separated value in the string has a calculator name followed by ‘:’ followed by the format for that calculator. With this example, sum will be formatted using ‘TOTAL={0:c}’, average with ‘AVG={0:c}' and count using ‘COUNT={0}’.
Note that you can also specify the string format on individual SummaryDefinition object using SummaryDefinition.StringFormat property.
Imports Infragistics.Windows Imports Infragistics.Windows.Editors Imports Infragistics.Windows.DataPresenter Private Sub Window1_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs) _dp.DataSource = _dataSource Dim fieldLayout As FieldLayout = _dp.FieldLayouts(0) Dim summary As SummaryDefinition = fieldLayout.SummaryDefinitions.Add(SummaryCalculator.Sum, "Price") ' StringFormat property's value is used to format the summary result using String's Format ' method. See .NET String.Format method for more information on available formatting options. summary.StringFormat = "Sum={0:C}" ' You can also specify a string format provider to use for the summary result. summary.StringFormatProvider = System.Globalization.CultureInfo.GetCultureInfo("fr-FR") ' Also note that SummaryStringFormats property of the Field can be used to control the format ' that gets assigned to summaries that the user selectes via the user interface (summary icon ' on the field label). This is in the format of "calculator_name1: format1, calculator_name2: format2". fieldLayout.Fields("Price").Settings.AllowSummaries = True fieldLayout.Fields("Price").SummaryStringFormats = _ "sum: TOTAL={0:c}, average: AVG={0:c}, count: COUNT={0}, minimum: MIN={0:c}, maximum: MAX={0:c}" End Sub
using Infragistics.Windows; using Infragistics.Windows.Editors; using Infragistics.Windows.DataPresenter; public void Window1_Loaded( object sender, RoutedEventArgs e ) { _dp.DataSource = _dataSource; FieldLayout fieldLayout = _dp.FieldLayouts[0]; SummaryDefinition summary = fieldLayout.SummaryDefinitions.Add( SummaryCalculator.Sum, "Price" ); // StringFormat property's value is used to format the summary result using String's Format // method. See .NET String.Format method for more information on available formatting options. summary.StringFormat = "Sum={0:C}"; // You can also specify a string format provider to use for the summary result. summary.StringFormatProvider = System.Globalization.CultureInfo.GetCultureInfo( "fr-FR" ); // Also note that SummaryStringFormats property of the Field can be used to control the format // that gets assigned to summaries that the user selectes via the user interface (summary icon // on the field label). This is in the format of "calculator_name1: format1, calculator_name2: format2". fieldLayout.Fields["Price"].Settings.AllowSummaries = true; fieldLayout.Fields["Price"].SummaryStringFormats = "sum: TOTAL={0:c}, average: AVG={0:c}, count: COUNT={0}, minimum: MIN={0:c}, maximum: MAX={0:c}"; }
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2