DataEngine for .NET Standard | ComponentOne
C1.PivotEngine Assembly / C1.PivotEngine Namespace / C1PivotEngine Class
Properties Methods Events


In This Topic
    C1PivotEngine Class Members
    In This Topic

    The following tables list the members exposed by C1PivotEngine.

    Public Constructors
     NameDescription
    Public ConstructorInitializes a new instance of a C1PivotEngine.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets a list of PivotField objects that define the fields shown as columns in the output table.  
    Public Property Gets or sets the object that contains data to be analyzed.  
    Public PropertyGets the list of PivotField objects exposed by the data source.  
    Public Property Gets the number of elements that are represented in the current view.  
    Public PropertyGets a list of PivotField objects that define the fields used as filters for the output table.  
    Public Property Gets a value that determines whether a PivotEngine view is currently defined.  
    Public Property Gets the number of elements that in the data source.  
    Public PropertyGets the default System.ComponentModel.IBindingList that exposes the data in the PivotTable.  
    Public PropertyGets the System.Data.DataTable that contains the output of the PivotEngine analysis.  
    Public PropertyGets a list of PivotField objects that define the fields shown as rows in the output table.  
    Public Property Gets or sets a value that determines whether the PivotEngine output table should include columns containing the row keys.  
    Public Property Gets or sets a value that determines whether the PivotEngine output table should include columns containing subtotals or grand totals.  
    Public Property Gets or sets a value that determines whether the PivotEngine output table should include rows containing subtotals or grand totals.  
    Public Property Gets or sets a value that determines whether the PivotEngine output table should use zeros to indicate missing values.  
    Public Property Gets or sets a value that indicates whether the summary data received from the server is already sorted. If this property is set to true, the PivotEngine will not sort the data it receives from the server.  
    Public Property Gets or sets a value that determines whether row and column totals should be displayed before or after regular data rows and columns. If this value is set to true, total rows appear above data rows and total columns appear on the left of regular data columns.  
    Public PropertyGets the first PivotField in the ValueFields collection, or null if the collection is empty.  
    Public PropertyGets a list of PivotField objects that define the fields summarized in the cells of the output table.  
    Public Property Gets or sets the PivotEngine view definition as an XML string.  
    Public Property Gets or sets the DataEngine workspace.  
    Top
    Public Methods
     NameDescription
    Public Method Suspend automatic updates to the output table while defining the PivotEngine view.  
    Public Method Requests cancellation of a pending request operation.  
    Public Method Connect to a C1.DataEngine table.  
    Public Method Clean up any resources being used.  
    Public Methodstatic (Shared in Visual Basic) Disposes the specified workspace and cancel all related tasks  
    Public Method Restore automatic updates to the output table after the PivotEngine view has been defined.  
    Public Methodstatic (Shared in Visual Basic)Overloaded.  Server-side asynchronous execution of a view returning aggregated results to the caller client.  
    Public MethodOverloaded. Gets a list of objects in the raw data source that define the content of a specific cell in the output table exposed by the PivotTable property.  
    Public Methodstatic (Shared in Visual Basic)Overloaded.  Makes source data rows used in obtaining a given aggregated value accessible to the server's clients.  
    Public Methodstatic (Shared in Visual Basic)Overloaded.  Lists fields with their types and provides other metadata for a DataEngine table.  
    Public MethodOverloaded. Gets the PivotKey associated with a System.Data.DataColumn on a PivotEngine table.  
    Public MethodOverloaded.  Makes the entire raw source data collection accessible to the server's clients.  
    Public Methodstatic (Shared in Visual Basic)Overloaded.  Lists unique values of a field for the server's clients.  
    Public MethodOverloaded.  Gets a string with a title describing the current view.  
    Public MethodOverloaded. Reads a PivotEngine view definition from an System.Xml.XmlReader.  
    Public Method Transposes the fields in the current view so rows become columns and columns become rows.  
    Public MethodCauses the PivotEngine to rebuild the output table exposed by the PivotTable property.  
    Public MethodOverloaded. Saves the current PivotEngine view definition into an System.Xml.XmlWriter.  
    Top
    Protected Methods
     NameDescription
    Protected Method  
    Protected Method  
    Protected MethodRaises the LoadedFields event.  
    Protected Method  
    Protected MethodRaises the Updated event.  
    Protected MethodRaises the UpdateError event.  
    Protected MethodRaises the Updating event.  
    Top
    Public Events
     NameDescription
    Public Event Occurs when calculation is cancelled.  
    Public EventFires after the PivotEngine finishes loading the fields for the current DataSource.  
    Public Event Occurs when calculation starts.  
    Public EventFires after the update of the C1PivotEngine is finished.  
    Public EventFires after the PivotEngine finishes its analysis and the output PivotTable is ready.  
    Public Event Fires when an error occurs while updating.  
    Public EventFires when the update progress of the C1PivotEngine is changed.  
    Public EventFires before the PivotEngine starts updating the output PivotTable.  
    Top
    Public Operators
    See Also