Kendo.Mvc.UI.PivotGrid

Kendo UI PivotGrid component

Properties

AutoBind

If set to false the widget will not bind to the data source during initialization. In this case data binding will occur when the change event of the data source is fired. By default the widget will bind to the data source specified in the configuration.

Reorderable

If set to false the user will not be able to add/close/reorder current fields for columns/rows/measures.

Excel

Configures the Kendo UI PivotGrid Excel export settings.

Pdf

Configures the Kendo UI PivotGrid PDF export settings.

Filterable

If set to true the user will be able to filter by using the field menu.

Sortable

If set to true the user could sort the pivotgrid by clicking the dimension fields. By default sorting is disabled.Can be set to a JavaScript object which represents the sorting configuration.

ColumnWidth

The width of the table columns. Value is treated as pixels.

Height

The height of the PivotGrid. Numeric values are treated as pixels.

ColumnHeaderTemplate

The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.

ColumnHeaderTemplateId

The id of the script element used for ColumnHeaderTemplate

DataCellTemplate

The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.

DataCellTemplateId

The id of the script element used for DataCellTemplate

RowHeaderTemplate

The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.

RowHeaderTemplateId

The id of the script element used for RowHeaderTemplate

Methods

SerializeSettings

Serialize current instance to Dictionary