XRGroupSortingSummary.Function Property

Specifies the arithmetic function to calculate.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v20.2.dll

NuGet Packages: DevExpress.Reporting.Core, DevExpress.WindowsDesktop.Reporting.Core

Declaration

C#

[SRCategory(ReportStringId.CatBehavior)]
public SortingSummaryFunction Function { get; set; }

VB.NET

<SRCategory(ReportStringId.CatBehavior)>
Public Property [Function] As SortingSummaryFunction

Property Value

Type	Description
SortingSummaryFunction	A SortingSummaryFunction enumeration value.

Available values:

Show 18 items

Name	Description
Avg	Calculates the average of all the values within the group.
Count	Counts the number of values within the group.
Sum	Calculates the total of all the values within the group.
Max	Calculates the maximum of all the values within the group.
Min	Calculates the minimum of all the values within the group.
Median	Finds the middle number within a sequence. Note that if the total number of elements is odd, this function returns the value of a middle number in a sequence. If the total number of elements is even, this function returns the arithmetical mean of the two middle numbers.
Var	Calculates the amount of variance for all the values within the group.
VarP	Calculates the population variance of all the values within the group.
StdDev	Calculates the standard deviation of all the values within the group.
StdDevP	Calculates the standard population deviation of all the values within the group.
DAvg	Calculates the average of all the distinct values within the group.
DCount	Counts the number of distinct values within the group.
DSum	Calculates the total of all the distinct values within the group.
DVar	Calculates the amount of variance for all the distinct values within the group.
DVarP	Calculates the population variance of all the distinct values within the group.
DStdDev	Calculates the standard deviation of all the distinct values within the group.
DStdDevP	Calculates the standard population deviation of all the distinct values within the group.
Custom	Calculates the custom summary using the GroupHeaderBand.SortingSummaryReset, GroupHeaderBand.SortingSummaryRowChanged and GroupHeaderBand.SortingSummaryGetResult events.

Remarks

The data field, on which the summary function is based, is defined via the XRGroupSortingSummary.FieldName property.

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