Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

XRGroupSortingSummary.IgnoreNullValues Property

Specifies whether null values should be ignored when a summary is calculated.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v24.2.dll

NuGet Package: DevExpress.Reporting.Core

#Declaration

[DefaultValue(false)]
[SRCategory(ReportStringId.CatBehavior)]
public bool IgnoreNullValues { get; set; }

#Property Value

Type Default Description
Boolean false

true to ignore null values; otherwise, false.

#Remarks

Use this property to specify whether null values should be ignored when a summary is calculated. If they are included they will be treated as zeros. For instance, for the SortingSummaryFunction.Avg summary function and the following set of values:

1, null, 5

with the IgnoreNullValues = true the Average function’s value will be 3, and

with the IgnoreNullValues = false the Average function’s value will be 2.

To learn more, see Grouping and Sorting a Report’s Data.

See Also