This example shows how to aggregate your data by string concatenation.

• Form1.cs (VB: Form1.vb)
• StringConcatFunction.cs (VB: StringConcatFunction.vb)

In this example, the Grid dashboard item displays СontactName values concatenated by country.

The following expressions aggregates data by string concatenation for СontactName values:

Call the CriteriaOperator.RegisterCustomFunction method to register a custom function in your project. The following code snippet shows how to register the numeric group interval's function:

Program.cs:

using System; using System.Windows.Forms using DevExpress.Data.Filtering; namespace Dashboard_StringConcatAggregate { static class Program { /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main() { // ... CriteriaOperator.RegisterCustomFunction(new StringConcatFunction()); Application.Run(new Form1()); } } }

Program.vb:

Imports System.Windows.Forms using DevExpress.Data.Filtering Namespace Dashboard_StringConcatAggregate Friend Module Program ''' <summary> ''' The main entry point for the application. ''' </summary> <STAThread> Sub Main() ' ... CriteriaOperator.RegisterCustomFunction(New StringConcatFunction()) Application.Run(New Form1()) End Sub End Module End Namespace 

• Expression Constants, Operators, and Functions
• Grouping
• ICustomFunctionOperatorBrowsable
• ICustomFunctionOperatorFormattable

• Dashboard for WinForms - How to Calculate the Numeric Group Interval
• Dashboard for WinForms - How to Calculate Fiscal Functions from Date-Time Data Fields