New to Telerik UI for ASP.NET AJAX? Start a free 30-day trial

Telerik.Web.UI.RadPivotGrid

RadPivotGrid control. See the http://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/overview Overview topicfor more information about this control.

Inheritance Hierarchy

System.Object
System.Web.UI.Control
System.Web.UI.WebControls.WebControl
System.Web.UI.WebControls.BaseDataBoundControl
System.Web.UI.WebControls.DataBoundControl
System.Web.UI.WebControls.CompositeDataBoundControl
Telerik.Web.UI.RadCompositeDataBoundControl : IControl, IControlResolver, IFeatureGroup, IPostBackDataHandler, IScriptControl, ISkinnableControl
Telerik.Web.UI.RadPivotGrid : IPostBackEventHandler

Properties

AccessibilitySettings `PivotGridAccessibilitySettings`

Gets a reference to the object that allows you to set the properties of the control's child controls for purpose and structure for user agents rendering to non-visual media such as speech and Braille

AccessKey `String`

Gets or sets the access key that allows you to quickly navigate to the Web server control.

AggregatesLevel `Int32`

Gets or sets a value that indicates the aggregate level.

AggregatesPosition `PivotGridAxis`

Gets or sets a value that indicates if the aggregate will be placed in the row axis or the column axis.

AllowFiltering `Boolean`

Gets or sets a value indicating whether the filtering feature is enabled.

AllowNaturalSort `Boolean`

Gets or sets a value indicating whether natural sorting is enabled.

AllowPaging `Boolean`

Gets or sets a value indicating whether the paging feature is enabled.

AllowSorting `Boolean`

Gets or sets a value indicating whether the sorting feature is enabled.

AlwaysAutoBindOnPostBack `Boolean`

Gets if the grid is always bound on post-back (when the view state is disabled).

BackColor `Color`

Gets or sets the background color of the Web server control.

BorderColor `Color`

Gets or sets the border color of the Web control.

BorderStyle `BorderStyle`

Gets or sets the border style of the Web server control.

BorderWidth `Unit`

Gets or sets the border width of the Web server control.

ClientIDMode `ClientIDMode`

This property is overridden in order to support controls which implement INamingContainer. The default value is changed to "AutoID".

ClientSettings `PivotGridClientSettings`

Gets a reference to the object that allows you to set the properties of the client-side behavior and appearance in a Telerik control.

CollapsedColumnIndexes `HashSet`1`

Gets a collection of the pivot grid's collapsed column groups indexes.

CollapsedRowIndexes `HashSet`1`

Gets a collection of the pivot grid's collapsed row groups indexes.

ColumnGrandTotalCellStyle `Style`

Style of the column grand totals' cells in the the pivotgrid.

ColumnGroupsDefaultExpanded `Boolean`

Gets or sets the default expand state of all column groups which will be applied on initial load.

ColumnHeaderCellStyle `Style`

Style of the column heades' cells in the the pivotgrid.

ColumnHeaderTable `PivotGridColumnHeaderTable`

Gets or sets the column header table

ColumnHeaderTableLayout `PivotGridColumnHeaderTable`

Gets or sets a value that indicates whether the column table layout is fixed or auto.

ColumnHeaderZoneText `String`

Gets or sets the column zone text when there are no items added to the column header zone.

ColumnTotalCellStyle `Style`

Style of the column totals' cells in the the pivotgrid.

ConfigurationPanel `PivotGridConfigurationPanel`

Represents the PivotGridConfigurationPanel control which is used to manipulate fields and AggregatesPosition and AggregatesLevel values

ConfigurationPanelSettings `PivotGridConfigurationPanelSettings`

Returns a reference to the object. This group contains all settings related to the

ContextMenu `PivotGridContextMenu`

Represents the ContextMenu RadMenu control

CssClass `String`

Gets or sets the Cascading Style Sheet (CSS) class rendered by the Web server control on the client.

CssClassFormatString `String`

The CssClass property will now be used instead of the former Skin and will be modified in AddAttributesToRender()

Culture `CultureInfo`

Get/set the selected culture. Localization strings will be loaded based on this value.

CurrentPageIndex `Int32`

Gets or sets a value indicating the index of the currently active page in case paging is enabled ( is true).

CustomPageSize `Nullable`1`

Stores a custom PageSize value if such is set when page mode is NextPrevAndNumeric

DataCellStyle `Style`

Style of the data cells in the the pivotgrid.

DataHeaderZoneText `String`

Gets or sets the data zone text when there are no items added to the data header zone.

DataMember `String`

Gets or sets the name of the list of data that the data-bound control binds to, in cases where the data source contains more than one distinct list of data items.

DataSource `Object`

Gets or sets the object from which the data-bound control retrieves its list of data items.

DataSourceID `Object`

Gets or sets the ID of the control from which the data-bound control retrieves its list of data items.

DataTable `PivotGridDataTable`

Gets or sets the data table

EmptyValue `String`

Gets or sets a value that will be displayed in data cells where aggragate values were empty.

EnableAjaxSkinRendering `String`

Gets or sets the value, indicating whether to render the skin CSS files during Ajax requests

Remarks

If EnableAjaxSkinRendering is set to false you will have to register the needed control base CSS file by hand when adding/showing the control with Ajax.

EnableAriaSupport `Boolean`

When set to true enables support for WAI-ARIA

EnableCaching `Boolean`

Gets or sets a string that indicates whether the pivot model should be persisted into the session cache.

EnableCachingInternal `Boolean`

Gets or sets a string that indicates whether the pivot model should be persisted into the session cache.

EnableConfigurationPanel `Boolean`

Gets or sets if the configuration panel will be enabled. For customization use .

Enabled `Boolean`

Gets or sets a value indicating whether the Web server control is enabled.

EnableEmbeddedBaseStylesheet `Boolean`

Gets or sets the value, indicating whether to render the link to the embedded base stylesheet of the control or not.

Remarks

If EnableEmbeddedBaseStylesheet is set to false you will have to register the needed control base CSS file by hand.

EnableEmbeddedScripts `Boolean`

Gets or sets the value, indicating whether to render script references to the embedded scripts or not.

Remarks

If EnableEmbeddedScripts is set to false you will have to register the needed Scripts files by hand.

EnableEmbeddedSkins `String`

Gets or sets the value, indicating whether to render links to the embedded skins or not.

Remarks

If EnableEmbeddedSkins is set to false you will have to register the needed CSS files by hand.

EnableNoRecordsTemplate `ITemplate`

Gets or sets a value indicating whether the NoRecordsTemplate will be visualized when no records are present

EnableRippleEffect `Boolean`

Returns true if ripple effect should be added

EnableTheming `Boolean`

Gets or sets a value indicating whether themes apply to this control.

EnableToolTips `Boolean`

Gets or sets a value indicating whether the ToolTips in the PivotGrid will be enabled feature.

EnableViewState `Boolean`

Gets or sets a value indicating whether the server control persists its view state, and the view state of any child controls it contains, to the requesting client.

EnableZoneContextMenu `Boolean`

Gets or sets a value indicating whether the zone context menu should be enabled.

ErrorValue `String`

Gets or sets a value that will be displayed in data cells where aggragate values could not be calculated.

ExportSettings `PivotGridExportSettings`

Gets a reference to the object that allows you to set the properties of the grouping operation in a Telerik RadGrid control.

Fields `PivotGridFieldsCollection`

Gets a collection of PivotGridFieldsCollection objects.

FieldSettings `List`1`

Field settings collection. Used by Persistence Framework.

FieldSettingsWindow `List`1`

Field settings window. Used by RadPivotGrid configuration panel. For more information, please examine the Configuration Panel topic.

FieldsPopupSettings `PivotGridFieldsPopupSettings`

Gets a reference to which holds all properties associated with the Fields Popup functionality which groups the fields in convinient popup in order to leave more space for the data to be displayed.

FieldsWindow `PivotGridFieldsCollection`

Represents the FieldsWindow RadWindow control which holds all hidden fields

FilterDialog `PivotGridFilterDialog`

Represents the dialogues that manages the filter expressions for the TOP/Bottom filter operators.

FilterHeaderZoneText `String`

Gets or sets the filter zone text when there are no items added to the filter header zone.

Filters `PivotGridFiltersCollection`

RadPivotGrid Filters collection. See the Filtering topic for more information.

FiltersPersistence `String`

Filters collection. Used internally by Persistence Framework.

FilterWindow `PivotGridFilterWindow`

Represents the window that manages the filter expressions for the pivot grid.

Font `FontInfo`

Gets the font properties associated with the Web server control.

ForeColor `Color`

Gets or sets the foreground color (typically the color of the text) of the Web server control.

Height `Unit`

Gets or sets the height of the Web server control.

Items `PivotGridItemCollection`

Gets a collection of RadPivotGridDataItem objects that represent the data items of the current page of data in a RadPivotGrid control

LocalizationPath `PivotGridStrings`

Gets or sets a value indicating where RadPivotGrid will look for its .resx localization file. By default this file should be in the App_GlobalResources folder. However, if you cannot put the resource file in the default location or .resx files compilation is disabled for some reason (e.g. in a DotNetNuke environment), this property should be set to the location of the resource file.

Remarks

If specified, the LocalizationPath property will allow you to load the grid localization file from any location in the web application.

NoRecordsTemplate `ITemplate`

Template that will be displayed if there is no aggregated data to show

NoRecordsText `String`

Gets or sets the text that will appear in the PivotGridNoRecordsItem when the default no records template is used.

OlapSettings `PivotGridOLAPSettings`

Gets a reference to the object that allows you to set the configuration parameters for OLAP binding in a Telerik control.

OuterTable `PivotGridOuterTable`

Gets or sets the outer table.

Overlay `Boolean`

Gets or sets a value indicating whether the Filter window of RadPivotGrid should have Overlay set to ensure popups are over a flash element or Java applet.

PageCount `Int32`

Gets the number of pages required to display the records of the data source in a control.

PagerStyle `PivotGridPagerStyle`

Style used to change the appearance and styling of the pager

PageSize `Int32`

Specify the maximum number of items that would appear in a page, when paging is enabled by property. Default value is 10.

RegisterWithScriptManager `Boolean`

Gets or sets the value, indicating whether to register with the ScriptManager control on the page.

Remarks

If RegisterWithScriptManager is set to false the control can be rendered on the page using Web Services or normal callback requests/page methods.

RenderEmptyStringInDataCells `Boolean`

Gets or sets a value that indicates whether the will be rendered into all empty data cells instead of empty string.

RenderMode `RenderMode`

Specifies the rendering mode of the control. Setting the mode to Lightweight will yield HTML 5/CSS 3 html and css.

Remarks

Lightweight rendering mode might change the outlook of the component in some older browsers that don't support CSS3/HTML5.

ResolvedRenderMode `RenderMode`

Returns resolved RenderMode should the original value was Auto

RowGrandTotalCellStyle `Style`

Style of the row grand totals' cells in the the pivotgrid.

RowGroupsDefaultExpanded `Boolean`

Gets or sets the default expand state of all row groups which will be applied on initial load.

RowHeaderCellStyle `Style`

Style of the row heades' cells in the the pivotgrid.

RowHeaderTable `PivotGridRowHeaderTable`

Gets or sets the row header table

RowHeaderTableLayout `PivotGridRowHeaderTable`

Gets or sets a value that indicates whether the row table layout is fixed or auto.

RowHeaderZoneText `String`

Gets or sets the header zone text when there are no items added to the row header zone.

RowTableLayout `PivotGridLayout`

Gets or sets a value that indicates whether the row table layout will be Tabular, Outline or Fixed.

RowTotalCellStyle `Style`

Style of the row totals' cells in the the pivotgrid.

RuntimeSkin `String`

Gets the real skin name for the control user interface. If Skin is not set, returns "Default", otherwise returns Skin.

ShouldBeBound `Boolean`

Gets if the grid should be data-bound.

ShowColumnHeaderZone `Boolean`

Gets or set a value indicating whether the column header zone of the pivotgrid will be shown.

ShowDataHeaderZone `Boolean`

Gets or set a value indicating whether the data header zone of the pivotgrid will be shown.

ShowFilterHeaderZone `Boolean`

Gets or set a value indicating whether the filter header zone of the pivotgrid will be shown.

ShowRowHeaderZone `Boolean`

Gets or set a value indicating whether the row header zone of the pivotgrid will be shown.

Skin `String`

Gets or sets the skin name for the control user interface.

Remarks

If this property is not set, the control will render using the skin named "Default". If EnableEmbeddedSkins is set to false, the control will not render skin.

Skin `String`

Gets or sets the skin name for the control user interface.

Remarks

If this property is not set, the control will render using the skin named "Default". If EnableEmbeddedSkins is set to false, the control will not render skin.