PivotGridFieldBase.ShowNewValues Property

Gets or sets whether field values that have appeared in the datasource after the field’s filtering was configured should be shown.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

[TypeConverter(typeof(BooleanTypeConverter))]
public bool ShowNewValues { get; set; }

VB.NET

<TypeConverter(GetType(BooleanTypeConverter))>
Public Property ShowNewValues As Boolean

Property Value

Type	Description
Boolean	true to show new field values; otherwise, false.

Remarks

If filtering is applied to the current field, the ShowNewValues property specifies whether new field values (values that have been added to the datasource after the filter condition was set) are shown or hidden by default.

If filtering is not applied to the field, new field values are always displayed, regardless of the ShowNewValues property value.

The ShowNewValues property is also not in effect if the current field is a part of a field group that uses a hierarchical filter (see PivotGridFieldOptions.GroupFilterMode). In this instance, use the group’s PivotGridGroup.ShowNewValues property.

Note

The ShowNewValues property internally sets the filter type. The true value corresponds to the PivotFilterType.Excluded filter type, while the false value corresponds to the PivotFilterType.Included filter type.

In Pivot Grid, end-users can enable or disable the ShowNewValues option via the toolbar button.

Note that if the ShowNewValues property is set at design time, all filter values will be unchecked on the first load. To avoid this behavior, set the ShowNewValues property after data binding.