The requested page is not available for the requested platform. You are viewing the content for Default platform.

PivotCustomGroupIntervalEventArgs.GroupValue Property

Gets or sets a group value.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v19.2.dll

Declaration

public object GroupValue { get; set; }
Public Property GroupValue As Object

Property Value

Type Description
Object

An object that represents the group value.

Remarks

The ASPxPivotGrid.CustomGroupInterval event enables you to group axis values using your own criteria. Use the GroupValue property to specify group values.

Examples

This example shows how to provide a custom criteria used to group axis values. The Custom Group Intervals feature is used to group product names and make the report more readable. The Product axis will show three intervals ("A-J", "K-S" and "T-Z").

The 'Products' field's PivotGridFieldBase.GroupInterval property is set to Custom at design-time. The grouping logic is implemented within the ASPxPivotGrid.CustomGroupInterval event handler.

The image below shows the result:

CustomGroupInterval

protected void ASPxPivotGrid1_CustomGroupInterval(object sender, 
    DevExpress.Web.ASPxPivotGrid.PivotCustomGroupIntervalEventArgs e)
{
    if (e.Field.Caption != "Products") return;
    if (Convert.ToChar(e.Value.ToString()[0]) < 'K')
    {
        e.GroupValue = "A-J";
        return;
    }
    if (Convert.ToChar(e.Value.ToString()[0]) > 'J' && Convert.ToChar(e.Value.ToString()[0]) < 'T')
    {
        e.GroupValue = "K-S";
        return;
    }
    if (Convert.ToChar(e.Value.ToString()[0]) > 'S')
        e.GroupValue = "T-Z";
}
See Also