PivotCustomGroupIntervalEventArgs.GroupValue Property
Gets or sets a group value.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v20.2.dll
NuGet Packages: DevExpress.WindowsDesktop.Wpf.PivotGrid, DevExpress.Wpf.PivotGrid
Declaration
Property Value
Type | Description |
---|---|
Object | An object that represents the group value. |
Remarks
The PivotGridControl.CustomGroupInterval event enables you to group axis values using your own criteria. Use the GroupValue property to specify group values.
Example
This example shows how to implement custom Group Intervals.
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.OleDb
Imports System.Windows
Imports DevExpress.Xpf.PivotGrid
Imports HowToBindToMDB.NwindDataSetTableAdapters
Imports System
Namespace HowToBindToMDB
''' <summary>
''' Interaction logic for MainWindow.xaml
''' </summary>
Partial Public Class MainWindow
Inherits Window
Private salesPersonDataTable As New NwindDataSet.SalesPersonDataTable()
Private salesPersonDataAdapter As New SalesPersonTableAdapter()
Public Sub New()
InitializeComponent()
pivotGridControl1.DataSource = salesPersonDataTable
End Sub
Private Sub Window_Loaded(ByVal sender As Object, ByVal e As RoutedEventArgs)
salesPersonDataAdapter.Fill(salesPersonDataTable)
pivotGridControl1.CollapseAllRows()
End Sub
Private Sub pivotGridControl1_CustomGroupInterval(ByVal sender As Object, _
ByVal e As PivotCustomGroupIntervalEventArgs)
If (Not Object.ReferenceEquals(e.Field, fieldProductGroup)) Then
Return
End If
Dim productName As String = Convert.ToString(e.Value)
If productName.Chars(0) < "F"c Then
e.GroupValue = "A-E"
ElseIf productName.Chars(0) > "E"c AndAlso productName.Chars(0) < "T"c Then
e.GroupValue = "F-S"
ElseIf productName.Chars(0) > "S"c Then
e.GroupValue = "T-Z"
End If
End Sub
End Class
End Namespace
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the GroupValue property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.