RadPivotGrid
Class
Definition
Namespace:Telerik.Web.UI
Assembly:Telerik.Web.UI.dll
Syntax:
C#
[EmbeddedSkin("PivotGrid", typeof(RadPivotGrid))]
[EmbeddedSkin("PivotGrid", "Default", typeof(RadPivotGrid))]
[ClientScriptResource("Telerik.Web.UI.RadPivotGrid", "Telerik.Web.UI.PivotGrid.RadPivotGridScripts.js")]
[RequiredCss("Telerik.Web.UI.Skins.Common.fonticons.css", RenderMode.Lightweight, typeof(RadPivotGrid))]
[RequiredScript(typeof(MaterialRipple))]
[RequiredCss("Telerik.Web.UI.Skins.Common.MaterialRipple.css", RenderMode.Lightweight, typeof(RadTreeList))]
[TelerikToolboxCategory("Data")]
public class RadPivotGrid : RadCompositeDataBoundControl, IScriptControl, IControlResolver, IPostBackDataHandler, ISkinnableControl, IControl, IFeatureGroup, IPostBackEventHandler, INamingContainer
Inheritance: objectRadCompositeDataBoundControlRadPivotGrid
Implements:
Inherited Members
Constructors
C#
public RadPivotGrid()
Fields
C#
public const string AggregateFunctionChangedCommandName = "AggregateFunctionChanged"
C#
public const string AggregateLabelChangeCommandName = "AggregateChange"
C#
public const string ChangePageSizeCommandName = "ChangePageSize"
C#
public const string DeselectAllCommandName = "DeselectAll"
C#
public const string DeselectCommandName = "Deselect"
C#
public const string ExpandCollapseCommandName = "ExpandCollapse"
C#
public const string ExpandCollapseLevelCommandName = "ExpandCollapseLevel"
C#
public const string FieldReorderCommandName = "FieldReorder"
C#
public const string FilterCommandName = "Filter"
C#
public const string FirstPageCommandArgument = "First"
C#
public const string InitFilterDialogueCommandName = "InitFilterDialogue"
C#
public const string LastPageCommandArgument = "Last"
C#
public const string NextPageCommandArgument = "Next"
C#
public const string PageCommandName = "Page"
C#
public const string PageSizeChangedCommandName = "PageSizeChanged"
C#
public const string PrevPageCommandArgument = "Prev"
C#
public const string RebindPivotGridCommandName = "RebindPivotGrid"
C#
public const string SelectAllCommandName = "SelectAll"
C#
public const string SelectCommandName = "Select"
C#
public const string ShowHideFieldCommandName = "ShowHideField"
C#
public const string SortCommandName = "Sort"
C#
public const string UpdateLayoutCommandName = "UpdateLayout"
Properties
C#
public PivotGridAccessibilitySettings AccessibilitySettings { get; }
C#
public int AggregatesLevel { get; set; }
C#
public PivotGridAxis AggregatesPosition { get; set; }
C#
public virtual bool AllowFiltering { get; set; }
C#
public virtual bool AllowNaturalSort { get; set; }
C#
public virtual bool AllowPaging { get; set; }
C#
public virtual bool AllowSorting { get; set; }
C#
[Browsable(false)]
public HashSet<PivotGridGroupSlot> AlreadyExpandedColumnSlots { get; }
C#
[Browsable(false)]
public HashSet<PivotGridGroupSlot> AlreadyExpandedRowSlots { get; }
C#
public PivotGridClientSettings ClientSettings { get; }
C#
[Browsable(false)]
public HashSet<Array> CollapsedColumnIndexes { get; }
C#
[Browsable(false)]
public HashSet<Array> CollapsedRowIndexes { get; }
C#
public virtual Style ColumnGrandTotalCellStyle { get; }
C#
public bool ColumnGroupsDefaultExpanded { get; set; }
C#
public virtual Style ColumnHeaderCellStyle { get; }
C#
public virtual PivotGridTableLayout ColumnHeaderTableLayout { get; set; }
C#
public virtual string ColumnHeaderZoneText { get; set; }
ColumnTotalCellStyle
Style
C#
public virtual Style ColumnTotalCellStyle { get; }
C#
public PivotGridConfigurationPanel ConfigurationPanel { get; }
C#
public PivotGridConfigurationPanelSettings ConfigurationPanelSettings { get; }
C#
public PivotGridContextMenu ContextMenu { get; }
C#
public CultureInfo Culture { get; set; }
C#
[Bindable(true)]
[Browsable(false)]
public int CurrentPageIndex { get; set; }
DataCellStyle
Style
C#
public virtual Style DataCellStyle { get; }
C#
public virtual string DataHeaderZoneText { get; set; }
C#
[Browsable(false)]
public bool DataSourceIsAssigned { get; }
C#
public virtual string EmptyValue { get; set; }
C#
public bool EnableAriaSupport { get; set; }
C#
public bool EnableCaching { get; set; }
C#
[Bindable(true)]
public virtual bool EnableConfigurationPanel { get; set; }
C#
[Browsable(true)]
[Bindable(true)]
public bool EnableNoRecordsTemplate { get; set; }
C#
public virtual bool EnableToolTips { get; set; }
C#
public virtual bool EnableZoneContextMenu { get; set; }
C#
public virtual string ErrorValue { get; set; }
C#
public PivotGridExportSettings ExportSettings { get; }
C#
public PivotGridFieldsCollection Fields { get; }
C#
public PivotGridFieldSettingsWindow FieldSettingsWindow { get; }
C#
public PivotGridFieldsPopupSettings FieldsPopupSettings { get; }
C#
public PivotGridFieldsWindow FieldsWindow { get; }
C#
public PivotGridFilterDialog FilterDialog { get; }
C#
public virtual string FilterHeaderZoneText { get; set; }
C#
[Browsable(false)]
public PivotGridFiltersCollection Filters { get; }
C#
public PivotGridFilterWindow FilterWindow { get; }
HorizontalScrollDiv
Panel
C#
public Panel HorizontalScrollDiv { get; }
C#
[Browsable(false)]
public bool IsFilterCommandInProgress { get; set; }
C#
protected bool IsNeedDataSourceInProgress { get; set; }
C#
[Browsable(false)]
public virtual PivotGridItemCollection Items { get; }
C#
public string LocalizationPath { get; set; }
NoRecordsTemplate
ITemplate
C#
[Browsable(false)]
[Bindable(false)]
public ITemplate NoRecordsTemplate { get; set; }
C#
public string NoRecordsText { get; set; }
C#
public PivotGridOLAPSettings OlapSettings { get; }
C#
public virtual PivotGridPagerStyle PagerStyle { get; }
C#
public bool RenderEmptyStringInDataCells { get; set; }
C#
public virtual Style RowGrandTotalCellStyle { get; }
C#
public bool RowGroupsDefaultExpanded { get; set; }
RowHeaderCellStyle
Style
C#
public virtual Style RowHeaderCellStyle { get; }
C#
public virtual PivotGridTableLayout RowHeaderTableLayout { get; set; }
C#
public virtual string RowHeaderZoneText { get; set; }
C#
public PivotGridLayout RowTableLayout { get; set; }
RowTotalCellStyle
Style
C#
public virtual Style RowTotalCellStyle { get; }
C#
[Bindable(true)]
public virtual bool ShowColumnHeaderZone { get; set; }
C#
[Bindable(true)]
public virtual bool ShowDataHeaderZone { get; set; }
C#
[Bindable(true)]
public virtual bool ShowFilterHeaderZone { get; set; }
C#
[Bindable(true)]
public virtual bool ShowRowHeaderZone { get; set; }
C#
public virtual PivotGridSortExpressionCollection SortExpressions { get; }
C#
protected override bool SupportsRenderingMode { get; }
Overrides:
TagKey
HtmlTextWriterTag
C#
protected override HtmlTextWriterTag TagKey { get; }
C#
public PivotGridToolTipManager ToolTipManager { get; }
C#
public PivotGridTotalsSettings TotalsSettings { get; }
C#
public virtual bool UseQueryableDataProvider { get; set; }
VerticalScrollDiv
Panel
C#
public Panel VerticalScrollDiv { get; }
Methods
C#
protected override void AddAttributesToRender(HtmlTextWriter writer)
Overrides:
C#
protected virtual void AutoDataBind(PivotGridRebindReason rebindReason)
C#
protected virtual void CallAddingFieldToZone(PivotGridAddingFieldToZoneEventArgs e)
C#
protected virtual void CallAggregateLabelChange(PivotGridAggregateLabelChangeEventArgs e)
C#
protected virtual void CallCreated(PivotGridCellCreatedEventArgs e)
C#
protected virtual void CallDataBound(PivotGridCellDataBoundEventArgs e)
C#
protected virtual void CallDataProviderError(PivotGridDataProviderErrorEventArgs e)
C#
protected virtual void CallDataProviderStatusChanged(DataProviderStatusChangedEventArgs e)
C#
protected virtual void CallExpandCollapseLevel(PivotGridExpandCollapseLevelEventArgs e)
C#
protected virtual void CallFieldCreated(PivotGridFieldCreatedEventArgs e)
C#
protected virtual void CallFieldReorder(PivotGridFieldReorderEventArgs e)
C#
protected virtual void CallItemCreated(PivotGridItemCreatedEventArgs e)
C#
protected virtual void CallItemDataBound(PivotGridItemDataBoundEventArgs e)
C#
protected virtual void CallShowHideField(PivotGridShowHideFieldEventArgs e)
C#
protected virtual void CallUpdateLayout(PivotGridUpdateLayoutEventArgs e)
C#
public void ClearAllFilters()
C#
public void CollapseAllFieldGroups(PivotGridColumnField field, bool suppressRebind = false)
C#
public void CollapseAllFieldGroups(PivotGridRowField field, bool suppressRebind = false)
C#
protected override int CreateChildControls(IEnumerable dataSource, bool dataBinding)
Overrides:
C#
public override void DataBind()
C#
protected override void DescribeComponent(IScriptDescriptor descriptor)
Overrides:
C#
public void ExpandAllFieldGroups(PivotGridColumnField field, bool suppressRebind = false)
C#
public void ExpandAllFieldGroups(PivotGridRowField field, bool suppressRebind = false)
C#
public void ExportToExcel()
C#
public void ExportToWord()
C#
public void FilterBottom(PivotGridField field, PivotGridAggregateField aggregateField, PivotGridAggregateType aggregateType, double value, bool suppressRebind = false)
C#
public void FilterByLabel(PivotGridFilterFunction filterFunction, PivotGridField field, string filterValue, bool suppressRebind = false)
C#
public void FilterByLabel(PivotGridFilterFunction filterFunction, PivotGridField field, string filterValue, string betweenFilterValue, bool suppressRebind = false, bool ignoreCase = false)
C#
public void FilterByValue(PivotGridFilterFunction filterFunction, PivotGridField field, PivotGridAggregateField aggregateField, string filterValue, bool suppressRebind = false)
C#
public void FilterByValue(PivotGridFilterFunction filterFunction, PivotGridField field, PivotGridAggregateField aggregateField, string filterValue, string betweenFilterValue, bool suppressRebind = false, bool ignoreCase = false)
C#
public void FilterTop(PivotGridField field, PivotGridAggregateField aggregateField, PivotGridAggregateType aggregateType, double value, bool suppressRebind = false)
C#
protected override DataSourceView GetData()
DataSourceView
C#
public PivotGridItem[] GetItems(params PivotGridItemType[] types)
C#
protected override IEnumerable<ScriptReference> GetScriptReferences()
IEnumerable<ScriptReference>
Overrides:
C#
public PivotGridZone GetZoneByType(PivotGridZoneType type)
C#
protected override bool LoadClientState(Dictionary<string, object> clientState)
Overrides:
C#
protected virtual void OnBiffExporting(PivotGridBiffExportingEventArgs e)
C#
protected virtual void OnFilterCommand(PivotGridFilterCommandEventArgs e)
C#
protected virtual void OnInitFilterDialogue(PivotGridInitFilterDialogueEventArgs e)
C#
protected virtual void OnItemCommand(PivotGridCommandEventArgs e)
C#
protected virtual void OnNeedDataSource(PivotGridNeedDataSourceEventArgs e)
C#
protected virtual void OnPageIndexChanged(PivotGridPageChangedEventArgs e)
C#
protected virtual void OnPageSizeChanged(PivotGridPageSizeChangedEventArgs e)
C#
protected virtual void OnPivotGridCellExporting(PivotGridCellExportingArgs e)
C#
protected virtual void OnPivotGridExporting(PivotGridExportingArgs e)
C#
protected virtual void OnPivotGridInfrastructureExporting(PivotGridInfrastructureExportingEventArgs e)
C#
protected override void PerformSelect()
C#
public virtual void Rebind()
C#
protected override void Render(HtmlTextWriter writer)
Overrides:
C#
protected override void RenderContents(HtmlTextWriter writer)
Overrides:
C#
public void SetFilterExcludes(string fieldUniqueName, IEnumerable<object> values, bool suppressRebind = false)
C#
public void SetFilterIncludes(string fieldUniqueName, IEnumerable<object> values, bool suppressRebind = false)
C#
protected virtual void SetStyleClasses()
C#
protected void SetUpPagingManager()
C#
public void Sort(PivotGridField field, bool suppressRebind = false)
C#
public void Sort(PivotGridField field, PivotGridSortOrder sortOrder, bool suppressRebind = false)
C#
public void Sort(PivotGridSortExpression expression, bool suppressRebind = false)
C#
public void Sort(string fieldUniqueName, PivotGridSortOrder sortOrder, bool suppressRebind = false)
C#
protected override void TrackViewState()
C#
public bool TryReorderField(PivotGridField field, PivotGridFieldZoneType zoneType, int zoneIndex)
C#
public bool TryReorderField(string fieldUniqueName, PivotGridFieldZoneType zoneType, int zoneIndex)
Events
C#
public event EventHandler<PivotGridAddingFieldToZoneEventArgs> AddingFieldToZone
C#
public event EventHandler<PivotGridCellCreatedEventArgs> CellCreated
C#
public event EventHandler<PivotGridCellDataBoundEventArgs> CellDataBound
C#
public event EventHandler<PivotGridDataProviderErrorEventArgs> DataProviderError
C#
public event EventHandler<DataProviderStatusChangedEventArgs> DataProviderStatusChanged
C#
public event EventHandler<PivotGridFieldCreatedEventArgs> FieldCreated
C#
public event EventHandler<GetDescriptionsDataCompletedEventArgs> GetDescriptionsDataCompleted
C#
public event EventHandler<PivotGridCommandEventArgs> ItemCommand
C#
public event EventHandler<PivotGridItemCreatedEventArgs> ItemCreated
C#
public event EventHandler<PivotGridCalculationEventArgs> ItemNeedCalculation
C#
public event EventHandler<PivotGridNeedDataSourceEventArgs> NeedDataSource
C#
public event EventHandler<PivotGridPageChangedEventArgs> PageIndexChanged
C#
public event EventHandler<PivotGridPageSizeChangedEventArgs> PageSizeChanged
C#
public event EventHandler<PivotGridBiffExportingEventArgs> PivotGridBiffExporting
C#
public event EventHandler<PivotGridCellExportingArgs> PivotGridCellExporting
C#
public event EventHandler<PivotGridExportingArgs> PivotGridExporting
C#
public event EventHandler<PivotGridInfrastructureExportingEventArgs> PivotGridInfrastructureExporting
C#
public event EventHandler<PivotGridPrepareDescriptionForFieldEventArgs> PrepareDescriptionForField
C#
public event EventHandler<PivotGridSortEventArgs> Sorting