CrossTabDataField.SummaryType Property

Specifies the summary function to calculate against a field.

Namespace: DevExpress.XtraReports.UI.CrossTab

Assembly: DevExpress.XtraReports.v23.2.dll

NuGet Package: DevExpress.Reporting.Core

Declaration

C#

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

VB.NET

<DefaultValue(SummaryType.Sum)>
<SRCategory(ReportStringId.CatData)>
Public Property SummaryType As SummaryType

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.

SummaryType = Sum

SummaryType = Average

SummaryType = Count

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).