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

CrossTabDataField.SummaryType Property

Specifies the summary function to calculate against a field.

Namespace: DevExpress.XtraReports.UI.CrossTab

Assembly: DevExpress.XtraReports.v24.2.dll

NuGet Package: DevExpress.Reporting.Core

#Declaration

[DefaultValue(SummaryType.Sum)]
[SRCategory(ReportStringId.CatData)]
public SummaryType SummaryType { get; set; }

#Property Value

Type Default Description
SummaryType Sum

The summary function.

Available values:

Show 12 items
Name Description
Count

The number of values.

Sum

The sum of all the values.

Min

The smallest value.

Max

The largest value.

Average

The average of all the values.

StdDev

The standard deviation of all the values.

StdDevp

The standard population deviation of all the values.

Var

The amount of variance for all the values.

Varp

The population variance for all the values.

CountDistinct

The number of unique values.

Median

The middle value in an ordered list of values.

Mode

The value that appears most frequently.

#Remarks

The Cross Tab summarizes values of data fields and displays the results at the intersection of the corresponding row and column.

Use the SummaryType property to change the type of the summary function. To access this property at design time, select a cell bound to the corresponding data field and click its smart tag. Alternatively, you can set this property in the Properties window.

The cell’s TextFormatString property allows you to format data accordingly.

Note

If a data field contains non-numeric values, you can only calculate the Count, Min and Max functions. Otherwise, zeros are displayed in the Cross Tab cells.

Use the SummaryDisplayType property to display results not “as is”, but in correlation with other cells (for instance, the percentage of grand total values).

See Also