[ToolboxBitmap(typeof(C1FlexPivotPanel), "C1FlexPivotPanel.png")]
[ComplexBindingProperties("DataSource", "DataMember")]
public class C1FlexPivotPanel : C1BasePanel, IDropTarget, ISynchronizeInvoke, IWin32Window, IBindableComponent, IComponent, IDisposable, IContainerControl, ISupportInitialize

Remarks

Olap pivot tables group data into one or more dimensions. The dimensions are represented by rows and columns on a grid, and the data is stored in the grid cells.

Use the DataSource property to set the source table, then use the FlexPivotTable property to get the output table.

If you use a C1FlexPivotGrid to show the output data, then set the grid's DataSource property to the appropriate C1FlexPivotPanel.

Constructors

Name	Description
C1FlexPivotPanel()	Initializes a new instance of a C1FlexPivotPanel.

Properties

Name	Description
DataMember	Gets or sets the specific list in a DataSource object to be analyzed.
DataSource	Gets or sets the object that contains the data to be analyzed.
FieldsContextMenu	References the context menu for field lists.
FlexPivotDefaultView	Gets the default IBindingList that exposes the data in the FlexPivotTable.
FlexPivotEngine	Gets a reference to the C1FlexPivotEngine that performs the FlexPivot analysis for this C1FlexPivotPanel.
FlexPivotTable	Gets a reference to the DataTable that contains the output of the FlexPivot analysis.
PivotEngine	Gets a reference to the C1PivotEngine that performs the FlexPivot analysis for this C1FlexPivotPanel.
ShowFieldsCheckBoxes	Determines whether checkboxes are displayed in the field list or not.
ShowTotalsColumns	Gets or sets a value that determines whether the FlexPivot output table should include columns containing subtotals or grand totals.
ShowTotalsForColumns	Gets or sets a value that determines whether the FlexPivot output table should include columns containing subtotals or grand totals.
ShowTotalsForRows	Gets or sets a value that determines whether the FlexPivot output table should include rows containing subtotals or grand totals.
ShowTotalsRows	Gets or sets a value that determines whether the FlexPivot output table should include rows containing subtotals or grand totals.
ShowZeros	Gets or sets a value that determines whether the FlexPivot output table should use zeros to indicate missing values.
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.
ViewDefinition	Gets or sets an XML string containing an FlexPivot view definition.
Workspace	Gets or sets the DataEngine workspace associated with the control.

Methods

Name	Description
BeginInit()
ConnectCube(string, string)	Connect to cube data source.
ConnectDataEngine(string)	Connect to a C1.DataEngine table.
CreateWorkspace()	Creates a new instance of Workspace class.
Dispose(bool)	Clean up any resources being used.
EndInit()
OnDataEngineConnectionChanged(EventArgs)	Raises the DataEngineConnectionChanged event.
OnDataSourceChanged(EventArgs)	Raises the DataSourceChanged event.
OnFontChanged(EventArgs)	Overriden to update context menu font.
OnLoadedFields(EventArgs)	Raises the LoadedFields event.
OnUpdated(EventArgs)	Raises the Updated event.
OnUpdating(EventArgs)	Raises the Updating event.
OnViewDefinitionChanged(EventArgs)	Raises the ViewDefinitionChanged event.

Events

Name	Description
DataEngineConnectionChanged	Occurs when data engine table connected.
DataSourceChanged	Occurs when the data source changes.
FieldSettingsDialogOpening	Occurs when the Field Settings dialog window is opening.
LoadedFields	Occurs after the PivotEngine finishes loading the fields for the current DataSource.
Updated	Occurs after the PivotEngine finishes the FlexPivot analysis.
Updating	Occurs before the PivotEngine starts updating the output FlexPivot table.
ViewDefinitionChanged	Occurs when the view definition changes, before the output table is updated.