名前 | 解説 | |
---|---|---|
C1PivotEngine コンストラクタ | Initializes a new instance of a C1PivotEngine. |
C1PivotEngineデータ型で公開されるメンバを以下の表に示します。
名前 | 解説 | |
---|---|---|
C1PivotEngine コンストラクタ | Initializes a new instance of a C1PivotEngine. |
名前 | 解説 | |
---|---|---|
ColumnFields | Gets a list of PivotField objects that define the fields shown as columns in the output table. | |
DataSource | Gets or sets the object that contains data to be analyzed. | |
Fields | Gets the list of PivotField objects exposed by the data source. | |
FilteredItemCount | Gets the number of elements that are represented in the current view. | |
FilterFields | Gets a list of PivotField objects that define the fields used as filters for the output table. | |
IsViewDefined | Gets a value that determines whether a PivotEngine view is currently defined. | |
ItemCount | Gets the number of elements that in the data source. | |
PivotDefaultView | Gets the default System.ComponentModel.IBindingList that exposes the data in the PivotTable. | |
PivotTable | Gets the System.Data.DataTable that contains the output of the PivotEngine analysis. | |
RowFields | Gets a list of PivotField objects that define the fields shown as rows in the output table. | |
ShowKeyColumns | Gets or sets a value that determines whether the PivotEngine output table should include columns containing the row keys. | |
ShowTotalsColumns | Gets or sets a value that determines whether the PivotEngine output table should include columns containing subtotals or grand totals. | |
ShowTotalsRows | Gets or sets a value that determines whether the PivotEngine output table should include rows containing subtotals or grand totals. | |
ShowZeros | Gets or sets a value that determines whether the PivotEngine output table should use zeros to indicate missing values. | |
SortOnServer | 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. | |
TotalsBeforeData | 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. | |
ValueField | Gets the first PivotField in the ValueFields collection, or null if the collection is empty. | |
ValueFields | Gets a list of PivotField objects that define the fields summarized in the cells of the output table. | |
ViewDefinition | Gets or sets the PivotEngine view definition as an XML string. | |
Workspace | Gets or sets the DataEngine workspace. |
名前 | 解説 | |
---|---|---|
BeginUpdate | Suspend automatic updates to the output table while defining the PivotEngine view. | |
CancelUpdate | Requests cancellation of a pending request operation. | |
ConnectDataEngine | Connect to a C1.DataEngine table. | |
Dispose | Clean up any resources being used. | |
DisposeWorkspace | Disposes the specified workspace and cancel all related tasks | |
EndUpdate | Restore automatic updates to the output table after the PivotEngine view has been defined. | |
Exec | オーバーロードされます。 Server-side asynchronous execution of a view returning aggregated results to the caller client. | |
ExecCube | ||
GetDetail | オーバーロードされます。 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. | |
GetDetails | オーバーロードされます。 Makes source data rows used in obtaining a given aggregated value accessible to the server's clients. | |
GetMetadata | オーバーロードされます。 Lists fields with their types and provides other metadata for a DataEngine table. | |
GetMetadataCube | ||
GetPivotKey | オーバーロードされます。 Gets the PivotKey associated with a System.Data.DataColumn on a PivotEngine table. | |
GetRawData | オーバーロードされます。 Makes the entire raw source data collection accessible to the server's clients. | |
GetUniqueValues | オーバーロードされます。 Lists unique values of a field for the server's clients. | |
GetUniqueValuesCube | ||
GetViewTitle | オーバーロードされます。 Gets a string with a title describing the current view. | |
ReadXml | オーバーロードされます。 Reads a PivotEngine view definition from an System.Xml.XmlReader. | |
TransposeFields | Transposes the fields in the current view so rows become columns and columns become rows. | |
Update | Causes the PivotEngine to rebuild the output table exposed by the PivotTable property. | |
WriteXml | オーバーロードされます。 Saves the current PivotEngine view definition into an System.Xml.XmlWriter. |
名前 | 解説 | |
---|---|---|
CancelUpdating | Occurs when calculation is cancelled. | |
LoadedFields | Fires after the PivotEngine finishes loading the fields for the current DataSource. | |
StartUpdating | Occurs when calculation starts. | |
UpdateCompleted | Fires after the update of the C1PivotEngine is finished. | |
Updated | Fires after the PivotEngine finishes its analysis and the output PivotTable is ready. | |
UpdateError | Fires when an error occurs while updating. | |
UpdateProgressChanged | Fires when the update progress of the C1PivotEngine is changed. | |
Updating | Fires before the PivotEngine starts updating the output PivotTable. |