FlexPivotPanel Class

Provides a user interface for interactively transforming regular data tables into FlexPivot pivot tables.

Inheritance

object

Visual

UIElement

FrameworkElement

Control

FlexPivotPanel

Implements

IAnimatable

IFrameworkInputElement

Namespace: C1.WPF.Pivot

Assembly: C1.WPF.Pivot.dll

Syntax

[TemplatePart(Name = "Root", Type = typeof(Grid))]
[TemplatePart(Name = "CubeFields", Type = typeof(C1TreeView))]
[TemplatePart(Name = "Fields", Type = typeof(ListBox))]
[TemplatePart(Name = "Filter", Type = typeof(ListBox))]
[TemplatePart(Name = "Rows", Type = typeof(ListBox))]
[TemplatePart(Name = "Columns", Type = typeof(ListBox))]
[TemplatePart(Name = "Values", Type = typeof(ListBox))]
[TemplatePart(Name = "CtxMenu", Type = typeof(ContextMenu))]
[TemplatePart(Name = "CmdMoveUp", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveDown", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveToBeg", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveToEnd", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveToRows", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveToCols", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveToVals", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdMoveToFilter", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdRemoveField", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdFieldSettings", Type = typeof(MenuItem))]
[TemplatePart(Name = "CmdTopSeparator", Type = typeof(Separator))]
[TemplatePart(Name = "BtnUpdate", Type = typeof(C1Button))]
[TemplatePart(Name = "ChkDeferUpdates", Type = typeof(CheckBox))]
public class FlexPivotPanel : Control, IAnimatable, IFrameworkInputElement, IInputElement, ISupportInitialize, IQueryAmbient, IDisposable

<TemplatePart(Name:="Root", Type:=GetType(Grid))>
<TemplatePart(Name:="CubeFields", Type:=GetType(C1TreeView))>
<TemplatePart(Name:="Fields", Type:=GetType(ListBox))>
<TemplatePart(Name:="Filter", Type:=GetType(ListBox))>
<TemplatePart(Name:="Rows", Type:=GetType(ListBox))>
<TemplatePart(Name:="Columns", Type:=GetType(ListBox))>
<TemplatePart(Name:="Values", Type:=GetType(ListBox))>
<TemplatePart(Name:="CtxMenu", Type:=GetType(ContextMenu))>
<TemplatePart(Name:="CmdMoveUp", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveDown", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveToBeg", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveToEnd", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveToRows", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveToCols", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveToVals", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdMoveToFilter", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdRemoveField", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdFieldSettings", Type:=GetType(MenuItem))>
<TemplatePart(Name:="CmdTopSeparator", Type:=GetType(Separator))>
<TemplatePart(Name:="BtnUpdate", Type:=GetType(C1Button))>
<TemplatePart(Name:="ChkDeferUpdates", Type:=GetType(CheckBox))>
Public Class FlexPivotPanel
    Inherits Control
    Implements IAnimatable, IFrameworkInputElement, IInputElement, ISupportInitialize, IQueryAmbient, IDisposable

Constructors

Name	Description
FlexPivotPanel()	Initializes a new instance of the FlexPivotPanel class.

Fields

Name	Description
DataSourceProperty	Identifies the DataSource dependency property.
ShowTotalsColumnsProperty	Identifies the ShowTotalsColumns dependency property.
ShowTotalsRowsProperty	Identifies the ShowTotalsRows dependency property.
ShowZerosProperty	Identifies the ShowZeros dependency property.
ThemeResourcesProperty	Identifies the ThemeResources dependency property.

Properties

Name	Description
C1PivotEngine	Gets a reference to the C1PivotEngine that performs the FlexPivot analysis for this FlexPivotPanel.
DataSource	Gets or sets the object that contains the data to be analyzed.
FlexPivotEngine	Gets a reference to the C1.FlexPivot.C1FlexPivotEngine that performs the FlexPivot analysis for this FlexPivotPanel.
FlexPivotTable	Gets a reference to the DataTable that contains the output of the FlexPivot analysis.
IsDisposed	Gets whether this instance is disposed.
ShowTotalsColumns	Gets or sets a value that determines whether the FlexPivot output table should include a column with the totals for each row.
ShowTotalsRows	Gets or sets a value that determines whether the FlexPivot output table should include a row with the totals for each column.
ShowZeros	Gets or sets a value that determines whether the FlexPivot output table should use zeros to indicate missing values.
ThemeResources	Gets or sets the ResourceDictionary defining theme resources to use in dialogs.
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
ConnectCube(string, string)	Connect to cube data source.
ConnectDataEngine(string)	Connect to a C1.DataEngine table.
CreateWorkspace()	Creates a new instance of C1.DataEngine.Workspace class.
Dispose()
Dispose(bool)
Finalize()	Finalizes this instance of the FlexPivotPanel class.
OnApplyTemplate()
OnDataEngineConnectionChanged(EventArgs)	Raises the DataEngineConnectionChanged event.
OnDataSourceChanged(EventArgs)	Raises the DataSourceChanged event.
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.
LoadedFields	Occurs after the FlexPivotEngine finishes loading the fields for the current DataSource.
Updated	Occurs after the FlexPivotEngine finishes the FlexPivot analysis.
Updating	Occurs before the C1PivotEngine starts updating the output FlexPivot table.
ViewDefinitionChanged	Occurs when the view definition changes, before the output table is updated.