Sql.Net Class Library Documentation

PivotTable Members

PivotTable overview

Public Instance Constructors

PivotTable Constructor Creates a new PivotTable instance

Public Instance Properties

BaseQuery Gets or sets the base query as a SelectQuery object
BaseSql Gets or sets the base query as a SQL string
Columns Gets the collection of PivotColumn objects
Function Gets or sets the function to be performed on ValueField
IsTotalColumnName Gets or sets the name of the column which indicates weather the row is a total summary row.
RowField Gets or sets the RowField name
ValueField Gets or sets the ValueField
WithIsTotal Gets or sets wheather IsTotal column should be added
WithTotal Gets or sets wheather totals should be calculated.

Public Instance Methods

BuildDrillDownSql Creates a SelectQuery which produces drill-down results
BuildPivotSql Creates a SelectQuery which produces the defined cross tab
Equals (inherited from Object) Determines whether the specified Object is equal to the current Object.
GetHashCode (inherited from Object) Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
GetType (inherited from Object) Gets the Type of the current instance.
ToString (inherited from Object) Returns a String that represents the current Object.

Protected Instance Methods

Finalize (inherited from Object) Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
MemberwiseClone (inherited from Object) Creates a shallow copy of the current Object.

See Also

PivotTable Class | Reeb.Reporting Namespace