Documentation

Class RadPivotGrid

RadPivotGrid is a control which provides functionality similar to the functionality of PivotTables in MS Excel. It aggregates large chunks of data and displays them in a human readable way.

Inheritance
System.Object
RadControl
RadPivotGrid
Inherited Members
Namespace: Telerik.WinControls.UI
Assembly: Telerik.WinControls.PivotGrid.dll

Syntax

[TelerikToolboxCategory("Data Controls")]
public class RadPivotGrid : RadControl, INotifyPropertyChanged, ISupportInitializeNotification, ISupportInitialize, IComponentTreeHandler, ILayoutHandler, IPCHost, IAnalyticsProvider, IPrintable, IChartDataProvider

Constructors

RadPivotGrid()

Initializes a new instance of the RadPivotGrid class.

Declaration
public RadPivotGrid()

Properties

AggregateDescriptions

A collection of PropertyAggregateDescription which describes how the values in the cells are calculated (aggregated).

Declaration
public AggregateDescriptionsCollection AggregateDescriptions { get; }
Property Value
AggregateDescriptionsCollection

AggregatesLevel

Gets or sets the depth of the Aggregates groups among the other groups when more than one aggregate is used.

Declaration
public int AggregatesLevel { get; set; }
Property Value
System.Int32

AggregatesPosition

Gets or sets the axis of the Aggregates groups when more than one aggregate is used.

Declaration
public PivotAxis AggregatesPosition { get; set; }
Property Value
PivotAxis

AllowContextMenu

Gets or sets a value indicating whether the built-in context menu is enabled.

Declaration
public bool AllowContextMenu { get; set; }
Property Value
System.Boolean

AllowDefaultScreenTips

Gets or sets a value indicating whether the built-in screen tips are enabled.

Declaration
public bool AllowDefaultScreenTips { get; set; }
Property Value
System.Boolean

AllowFieldsDragDrop

Gets or sets a value indicating whether the fields can be reorganized via drag and drop.

Declaration
public bool AllowFieldsDragDrop { get; set; }
Property Value
System.Boolean

AllowGroupFiltering

Gets or sets a value indicating whether Group Filtering is enabled.

Declaration
public bool AllowGroupFiltering { get; set; }
Property Value
System.Boolean

AllowHorizontalResize

Gets or sets a value indicating whether the user is able to resize columns.

Declaration
public bool AllowHorizontalResize { get; set; }
Property Value
System.Boolean

AllowSelection

Gets or sets a value indicating whether the user is able to select cells.

Declaration
public bool AllowSelection { get; set; }
Property Value
System.Boolean

AllowSorting

Gets or sets a value indicating whether the user is able to sort the group labels.

Declaration
public bool AllowSorting { get; set; }
Property Value
System.Boolean

AllowVerticalResize

Gets or sets a value indicating whether the user is able to resize rows.

Declaration
public bool AllowVerticalResize { get; set; }
Property Value
System.Boolean

AutoExpandColumnHeaders

Gets or sets a value indicating whether the created column groups should be initially expanded.

Declaration
public bool AutoExpandColumnHeaders { get; set; }
Property Value
System.Boolean

AutoExpandRowHeaders

Gets or sets a value indicating whether the newly created row groups should be initially expanded.

Declaration
public bool AutoExpandRowHeaders { get; set; }
Property Value
System.Boolean

AutoSize

Gets or sets whether the edit control is auto-sized

Declaration
public override bool AutoSize { get; set; }
Property Value
System.Boolean

Overrides

BackColor

RadPivotGrid consists of multiple visual elements and separate settings are provided to customize their appearance. Current BackColor property might be ignored.

Declaration
public override Color BackColor { get; set; }
Property Value
System.Drawing.Color

Overrides

ChartDataProvider

Gets or sets the chart data provider.

Declaration
public PivotGridChartDataProvider ChartDataProvider { get; set; }
Property Value
PivotGridChartDataProvider

The chart data provider.

ColumnGrandTotalsPosition

Gets or sets the position of the GrandTotal column in the Columns axis.

Declaration
public TotalsPos ColumnGrandTotalsPosition { get; set; }
Property Value
TotalsPos

ColumnGroupDescriptions

A collection of PropertyGroupDescriptionBase which is used for generating column groups.

Declaration
public ColumnGroupDescriptionCollection ColumnGroupDescriptions { get; }
Property Value
ColumnGroupDescriptionCollection

ColumnGroupsExpandBehavior

Gets or sets the behavior that will set the expand or collapse state for column IGroups.

Declaration
public IItemExpandBehavior<ExpandBehaviorParameters> ColumnGroupsExpandBehavior { get; set; }
Property Value
IItemExpandBehavior<ExpandBehaviorParameters>

ColumnHeaderHeight

Gets or sets the height of the column headers area.

Declaration
public int ColumnHeaderHeight { get; set; }
Property Value
System.Int32

ColumnHeadersLayout

Gets or sets the layout type of the column headers.

Declaration
public PivotLayout ColumnHeadersLayout { get; set; }
Property Value
PivotLayout

ColumnsSubTotalsPosition

Gets or sets the position of the SubTotal columns in the Columns axis.

Declaration
public TotalsPos ColumnsSubTotalsPosition { get; set; }
Property Value
TotalsPos

ColumnWidth

Gets or sets the default column width for all columns.

Declaration
public int ColumnWidth { get; set; }
Property Value
System.Int32

DataMember

Gets or sets the name of the list or table in the data source for which RadPivotGrid is displaying aggregated data.

Declaration
public string DataMember { get; set; }
Property Value
System.String

DataProvider

Gets or sets the IDataProvider that populates the pivot grid with data.

Declaration
public IDataProvider DataProvider { get; set; }
Property Value
IDataProvider

DataSource

Gets or sets the data source for which RadPivotGrid is displaying aggregated data.

Declaration
public object DataSource { get; set; }
Property Value
System.Object

DefaultSize

Gets the default size of the control.

Declaration
protected override Size DefaultSize { get; }
Property Value
System.Drawing.Size

The default System.Drawing.Size of the control.

DialogsFactory

Gets or sets the dialogs factory.

Declaration
public PivotGridDialogsFactory DialogsFactory { get; set; }
Property Value
PivotGridDialogsFactory

The dialogs factory.

EmptyValueString

Gets or sets the string that will appears on cells that do not have a value.

Declaration
public string EmptyValueString { get; set; }
Property Value
System.String

ErrorString

Gets or sets the string that will appears on cells for which an error has occured during calculation.

Declaration
public string ErrorString { get; set; }
Property Value
System.String

FilterAreaHeight

Gets or sets the height of the report filters area.

Declaration
public int FilterAreaHeight { get; set; }
Property Value
System.Int32

FilterDescriptions

A collection of PropertyFilterDescription which defines the fields that are available in the Report Filters area.

Declaration
public FilterDescriptionsCollection FilterDescriptions { get; }
Property Value
FilterDescriptionsCollection

ForeColor

RadPivotGrid consists of multiple visual elements and separate settings are provided to customize their appearance. Current ForeColor property might be ignored.

Declaration
public override Color ForeColor { get; set; }
Property Value
System.Drawing.Color

Overrides

LayoutState

Gets or sets an object which holds the state of the resized and the collapsed rows and columns. Setting the object will apply the state and will update the layout.

Declaration
public PivotLayoutState LayoutState { get; set; }
Property Value
PivotLayoutState

PivotGridElement

Gets the pivot grid element.

Declaration
public RadPivotGridElement PivotGridElement { get; }
Property Value
RadPivotGridElement

The pivot grid element.

PrintStyle

Gets or sets the PivotGridPrintStyle that is responsible for printing the pivot grid.

Declaration
public PivotGridPrintStyle PrintStyle { get; set; }
Property Value
PivotGridPrintStyle

RowGrandTotalsPosition

Gets or sets the position of the GrandTotal row in the Rows axis.

Declaration
public TotalsPos RowGrandTotalsPosition { get; set; }
Property Value
TotalsPos

RowGroupDescriptions

A collection of PropertyGroupDescriptionBase which is used for generating row groups.

Declaration
public RowGroupDescriptionCollection RowGroupDescriptions { get; }
Property Value
RowGroupDescriptionCollection

RowGroupsExpandBehavior

Gets or sets the behavior that will set the expand or collapse state for row IGroups.

Declaration
public IItemExpandBehavior<ExpandBehaviorParameters> RowGroupsExpandBehavior { get; set; }
Property Value
IItemExpandBehavior<ExpandBehaviorParameters>

RowHeadersLayout

Gets or sets the layout type of the row headers.

Declaration
public PivotLayout RowHeadersLayout { get; set; }
Property Value
PivotLayout

RowHeight

Gets or sets the default row height for all rows.

Declaration
public int RowHeight { get; set; }
Property Value
System.Int32

RowsSubTotalsPosition

Gets or sets the position of the SubTotal rows in the Rows axis.

Declaration
public TotalsPos RowsSubTotalsPosition { get; set; }
Property Value
TotalsPos

ShowFilterArea

Gets or sets a value indicating whether the Report Filters area should be displayed.

Declaration
public bool ShowFilterArea { get; set; }
Property Value
System.Boolean

Text

This property is not relevant for this class.

Declaration
public override string Text { get; set; }
Property Value
System.String

Overrides

XmlSerializationInfo

Gets the serialization info for RadPivotGrid used by Save/Load loyout methods to persist grid settings to/from XML. By default or when set to null the ComponentXmlSerializationInfo provided by GetDefaultXmlSerializationInfo() will be used.

Declaration
public ComponentXmlSerializationInfo XmlSerializationInfo { get; set; }
Property Value
ComponentXmlSerializationInfo

Methods

BeginInit()

Suspends layout during initialization.

Declaration
public override void BeginInit()
Overrides

BeginUpdate()

Puts RadPivotGrid in update mode and suspends refreshing the view.

Declaration
public void BeginUpdate()

CreateChildItems(RadElement)

Creates the child items.

Declaration
protected override void CreateChildItems(RadElement parent)
Parameters
RadElement parent

The parent.
Overrides

CreatePivotGridElement()

Creates the pivot grid element.

Declaration
protected virtual RadPivotGridElement CreatePivotGridElement()
Returns
RadPivotGridElement

CreateXmlSerializer(ComponentXmlSerializationInfo)

Creates the XML serializer.

Declaration
protected virtual ComponentXmlSerializer CreateXmlSerializer(ComponentXmlSerializationInfo info)
Parameters
ComponentXmlSerializationInfo info

The info.
Returns
ComponentXmlSerializer

EndInit()

Resumes layout.

Declaration
public override void EndInit()
Overrides

EndUpdate()

Ends the update mode and refreshes the view.

Declaration
public void EndUpdate()

GetDefaultXmlSerializationInfo()

Gets the default serialization info for RadPivotGrid used by Save/Load loyout methods to persist grid settings to/from XML.

Declaration
protected virtual ComponentXmlSerializationInfo GetDefaultXmlSerializationInfo()
Returns
ComponentXmlSerializationInfo

The default serialization info.

IsInputKey(Keys)

Determines whether the specified key is a regular input key or a special key that requires preprocessing.

Declaration
protected override bool IsInputKey(Keys keyData)
Parameters
System.Windows.Forms.Keys keyData

One of the System.Windows.Forms.Keys values.
Returns
System.Boolean

true if the specified key is a regular input key; otherwise, false.
Overrides

LoadLayout(Stream)

Loads RadPivotGrid properties, sub-objects and their properties from XML stream, using the serialization information provided by the XmlSerializationInfo property

Declaration
public virtual void LoadLayout(Stream stream)
Parameters
System.IO.Stream stream

LoadLayout(String)

Loads RadPivotGrid properties, sub-objects and their properties from XML file, using the serialization information provided by the XmlSerializationInfo property

Declaration
public virtual void LoadLayout(string fileName)
Parameters
System.String fileName

LoadLayout(XmlReader)

Loads RadPivotGrid properties, sub-objects and their properties from XML reader, using the serialization information provided by the XmlSerializationInfo property

Declaration
public virtual void LoadLayout(XmlReader xmlReader)
Parameters
System.Xml.XmlReader xmlReader

OnKeyDown(KeyEventArgs)

Raises the System.Windows.Forms.Control.KeyDown event.

Declaration
protected override void OnKeyDown(KeyEventArgs e)
Parameters
System.Windows.Forms.KeyEventArgs e

A System.Windows.Forms.KeyEventArgs that contains the event data.
Overrides

OnLostFocus(EventArgs)

Raises the System.Windows.Forms.Control.LostFocus event.

Declaration
protected override void OnLostFocus(EventArgs e)
Parameters
System.EventArgs e

An System.EventArgs that contains the event data.
Overrides

OnMouseDown(MouseEventArgs)

Raises the System.Windows.Forms.Control.MouseDown event.

Declaration
protected override void OnMouseDown(MouseEventArgs e)
Parameters
System.Windows.Forms.MouseEventArgs e

A System.Windows.Forms.MouseEventArgs that contains the event data.
Overrides

OnMouseMove(MouseEventArgs)

Raises the System.Windows.Forms.Control.MouseMove event.

Declaration
protected override void OnMouseMove(MouseEventArgs e)
Parameters
System.Windows.Forms.MouseEventArgs e

A System.Windows.Forms.MouseEventArgs that contains the event data.
Overrides

OnMouseUp(MouseEventArgs)

Raises the MouseUp event.

Declaration
protected override void OnMouseUp(MouseEventArgs e)
Parameters
System.Windows.Forms.MouseEventArgs e

The System.Windows.Forms.MouseEventArgs instance containing the event data.
Overrides

OnMouseWheel(MouseEventArgs)

Raises the System.Windows.Forms.Control.MouseWheel event.

Declaration
protected override void OnMouseWheel(MouseEventArgs e)
Parameters
System.Windows.Forms.MouseEventArgs e

A System.Windows.Forms.MouseEventArgs that contains the event data.
Overrides

OnScreenTipNeeded(Object, ScreenTipNeededEventArgs)

Called when the screen tip is needed.

Declaration
protected override void OnScreenTipNeeded(object sender, ScreenTipNeededEventArgs e)
Parameters
System.Object sender

The sender.
ScreenTipNeededEventArgs e

The ScreenTipNeededEventArgs instance containing the event data.
Overrides

Print()

Directly prints the RadPivotGrid to the default printer.

Declaration
public virtual void Print()

Print(Boolean)

Directly prints the RadPivotGrid to the default printer or shows printer settitngs and then prints the RadPivotGrid.

Declaration
public virtual void Print(bool showPrinterSettings)
Parameters
System.Boolean showPrinterSettings

Indicates whether printer settings dialog should be shown.

Print(Boolean, RadPrintDocument)

Directly prints the RadPivotGrid to the default printer or shows printer settitngs and then prints the RadPivotGrid.

Declaration
public virtual void Print(bool showPrinterSettings, RadPrintDocument document)
Parameters
System.Boolean showPrinterSettings

Indicates whether printer settings dialog should be shown.
RadPrintDocument document

As instance of RadPrintDocument used to control the print process.

PrintPreview()

Shows a RadPrintPreviewDialog for editing the RadPivotGrid print settings.

Declaration
public virtual void PrintPreview()

PrintPreview(RadPrintDocument)

Shows a RadPrintPreviewDialog for editing the RadPivotGrid print settings.

Declaration
public virtual void PrintPreview(RadPrintDocument document)
Parameters
RadPrintDocument document

As instance of RadPrintDocument used to control the print process.

ReloadData()

Recalculated the displayed information and refreshes the view.

Declaration
public void ReloadData()

SaveLayout(Stream)

Stores to a stream RadPivotGrid properties, sub-objects and their properties in XML format, using the serialization information provided by the XmlSerializationInfo property

Declaration
public virtual void SaveLayout(Stream stream)
Parameters
System.IO.Stream stream

SaveLayout(String)

Stores to a file RadPivotGrid properties, sub-objects and their properties in XML format, using the serialization information provided by the XmlSerializationInfo property

Declaration
public virtual void SaveLayout(string fileName)
Parameters
System.String fileName

SaveLayout(XmlWriter)

Stores RadPivotGrid properties, sub-objects and their properties in XML format, using the serialization information provided by the XmlSerializationInfo property

Declaration
public virtual void SaveLayout(XmlWriter xmlWriter)
Parameters
System.Xml.XmlWriter xmlWriter

XmlWriter to use by the built-in serializer

ShowFieldList()

Shows the PivotFieldChooserForm which allows you to pick fields that are not currently available in RadPivotGrid.

Declaration
public void ShowFieldList()

Events

AggregateDescriptorElementCreating

Fires when an aggregate descriptor element is being created. Allows for replacing it with a custom element.

Declaration
public event AggregateDescriptorElementCreatingEventHandler AggregateDescriptorElementCreating
Event Type
AggregateDescriptorElementCreatingEventHandler

AggregatesPositionElementCreating

Fires when the aggregate position element is being created. Allows for replacing it with a custom element.

Declaration
public event AggregatesPositionElementCreatingEventHandler AggregatesPositionElementCreating
Event Type
AggregatesPositionElementCreatingEventHandler

CellCreating

Fires when a cell element is being created. Allows for replacing the default elements with custom ones.

Declaration
public event PivotCellCreatingEventHandler CellCreating
Event Type
PivotCellCreatingEventHandler

CellFormatting

Fires when a cell element is updated. Allows for customizing the appearance of the cells.

Declaration
public event PivotCellEventHandler CellFormatting
Event Type
PivotCellEventHandler

DataProviderChanged

Fires when the DataProvider property has changed.

Declaration
public event DataProviderChangedEventHandler DataProviderChanged
Event Type
DataProviderChangedEventHandler

FilterDescriptorElementCreating

Fires when a filter descriptor element is being created. Allows for replacing it with a custom element.

Declaration
public event FilterDescriptorElementCreatingEventHandler FilterDescriptorElementCreating
Event Type
FilterDescriptorElementCreatingEventHandler

GroupDescriptorElementCreating

Fires when a group descriptor element is being created. Allows for replacing it with a custom element.

Declaration
public event GroupDescriptorElementCreatingEventHandler GroupDescriptorElementCreating
Event Type
GroupDescriptorElementCreatingEventHandler

GroupElementCreating

Fires when a group element is being created. Allows for replacing the default group elements.

Declaration
public event PivotGroupElementCreatingEventHandler GroupElementCreating
Event Type
PivotGroupElementCreatingEventHandler

GroupElementFormatting

Fires when a group element is updated. Allows for customizing its appearance.

Declaration
public event PivotGroupElementEventHandler GroupElementFormatting
Event Type
PivotGroupElementEventHandler

GroupExpandedChanged

Fires when a group is expanded or collapsed.

Declaration
public event PivotGroupEventHandler GroupExpandedChanged
Event Type
PivotGroupEventHandler

PrintElementFormatting

Fires when a print element is being prepared for painting.

Declaration
public event PrintElementEventHandler PrintElementFormatting
Event Type
PrintElementEventHandler

PrintElementPaint

Fires when the print element has been painted. Allows for adding custom painting.

Declaration
public event PrintElementPaintEventHandler PrintElementPaint
Event Type
PrintElementPaintEventHandler

RowCreating

Fires when a row element is being created. Allows for replacing the default elements with custom ones.

Declaration
public event PivotRowCreatingEventHandler RowCreating
Event Type
PivotRowCreatingEventHandler

RowFormatting

Fires when a row element is updated.

Declaration
public event PivotRowEventHandler RowFormatting
Event Type
PivotRowEventHandler

SelectionChanged

Fires when the selection in RadPivotGrid has changed.

Declaration
public event EventHandler SelectionChanged
Event Type
System.EventHandler

UpdateCompleted

Fires when the data provider has finished building the data and the UI was updated.

Declaration
public event EventHandler UpdateCompleted
Event Type
System.EventHandler

Explicit Interface Implementations

IChartDataProvider.SetChartView(ChartView)

Declaration
void IChartDataProvider.SetChartView(ChartView chartView)
Parameters
ChartView chartView

Implements

IChartDataProvider.UpdateChartData()

Declaration
void IChartDataProvider.UpdateChartData()
Implements

IPrintable.BeginPrint(RadPrintDocument, PrintEventArgs)

Declaration
int IPrintable.BeginPrint(RadPrintDocument sender, PrintEventArgs args)
Parameters
RadPrintDocument sender

System.Drawing.Printing.PrintEventArgs args

Returns
System.Int32

Implements

IPrintable.EndPrint(RadPrintDocument, PrintEventArgs)

Declaration
bool IPrintable.EndPrint(RadPrintDocument sender, PrintEventArgs args)
Parameters
RadPrintDocument sender

System.Drawing.Printing.PrintEventArgs args

Returns
System.Boolean

Implements

IPrintable.GetSettingsDialog(RadPrintDocument)

Declaration
Form IPrintable.GetSettingsDialog(RadPrintDocument document)
Parameters
RadPrintDocument document

Returns
System.Windows.Forms.Form

Implements

IPrintable.PrintPage(Int32, RadPrintDocument, PrintPageEventArgs)

Declaration
bool IPrintable.PrintPage(int pageNumber, RadPrintDocument sender, PrintPageEventArgs args)
Parameters
System.Int32 pageNumber

RadPrintDocument sender

System.Drawing.Printing.PrintPageEventArgs args

Returns
System.Boolean

Implements

Extension Methods