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