MESCIUS.ActiveReports.Core.Data.DataEngine Assembly / GrapeCity.Enterprise.Data.DataEngine.Aggregates Namespace / AggregateFunction Enumeration

AggregateFunction Enumeration
Specifies the available intrinsic aggregate function names
Syntax
'Declaration
 
Public Enum AggregateFunction 
   Inherits System.Enum
 
Members
MemberDescription
AggregateReturns an aggregate defined by the data provider
AggregateIfDetermines the AggregateIf value for a list of facts
AvgUses Sum+Count to calculate average
CountCounts non-null values for each record in a list of facts
CountDistinctCounts based on distinct values of an expression for each record in a list of Facts
CountRowsCounts all records
DistinctSumDetermines the DistinctSum value for a list of facts
EmptyRepresents an undefined aggregate function. This value is used to indicate the absence of a function.
FirstDetermines the first value of a list of facts
LastDetermines the last value of a list of facts
MaxMax of all values in a list of facts
MedianDetermines the median value for a list of facts
MinMin of all values in a list of facts
ModeDetermines the mode value for a list of facts
StDevBorrows from Var (Square Root of Var)
StDevPBorrows from VarP (Square Root of VarP)
SumCalculates sum of non-null values for each record in a list of facts
ToArrayReturns records as array
VarBorrows from SumSquare, Sum, & Count
VarPBorrows from SumSquare, Sum, & Count
Remarks
This type should not be used directly in application code. It is designed for internal operations within the product libraries and may change or be removed in future versions without notice.
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Enterprise.Data.DataEngine.Aggregates.AggregateFunction

See Also