Interface IPivotControl

Provides complete functionality of the Pivot control.

Namespace: Syncfusion.PivotAnalysis.Base

Assembly: Syncfusion.PivotAnalysis.Base.dll

Syntax

public interface IPivotControl

Properties

DeferLayoutUpdate

When the property is enabled, you can add, remove and move fields around without updating the PivotTable at every instance. When you are done arranging the fields, you can use the update option to update the PivotTable on-demand.

Declaration

bool DeferLayoutUpdate { get; set; }

Property Value

Type
System.Boolean

Filters

Gets the number of filter expressions present in the Pivot control.

Declaration

ObservableCollection<FilterExpression> Filters { get; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<FilterExpression>

ItemSource

Gets or sets the data source for the Pivot control. The data source should be either an IEnumerable List or a DataTable.

Declaration

object ItemSource { get; set; }

Property Value

Type
System.Object

PivotCalculations

Gets the number of PivotCalculations present in the value section of Pivot control.

Declaration

ObservableCollection<PivotComputationInfo> PivotCalculations { get; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotComputationInfo>

PivotColumns

Gets the number of PivotItems present in the column section of Pivot control.

Declaration

ObservableCollection<PivotItem> PivotColumns { get; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotItem>

PivotEngine

It is used to hold and populate the Pivoted data.

Declaration

PivotEngine PivotEngine { get; set; }

Property Value

Type
PivotEngine

PivotFields

Gets the number of PivotItems present in the field section of Pivot control.

Declaration

ObservableCollection<PivotItem> PivotFields { get; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotItem>

PivotRows

Gets the number of PivotItems present in the row section of Pivot control.

Declaration

ObservableCollection<PivotItem> PivotRows { get; }

Property Value

Type
System.Collections.ObjectModel.ObservableCollection<PivotItem>

ShowCalculationsAsColumns

To show PivotCalculations either in column or row section of Pivot control. The default value is column.

Declaration

bool ShowCalculationsAsColumns { get; set; }

Property Value

Type
System.Boolean

Events

ShowDisabledGroupBackgroundPropertyChanged

This event is used to specify whether the PivotItems are in disable state or not. The default value is false.

Declaration

event EventHandler ShowDisabledGroupBackgroundPropertyChanged

Event Type

Type
System.EventHandler