Back to all docs
API Reference / Kendo.Mvc.UI.Fluent / PivotGridBuilder<TModel>
New to Telerik UI for ASP.NET MVC? Start a free 30-day trial

PivotGridBuilder<TModel>

Class

Defines the fluent interface for configuring the PivotGrid<TModel>.

Definition

Namespace:Kendo.Mvc.UI.Fluent

Assembly:Kendo.Mvc.dll

Type Parameters:

TModel

Syntax:
C#
public class PivotGridBuilder<TModel> : WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>, IHtmlString where TModel : class

Inheritance: objectWidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>PivotGridBuilder<TModel>

Implements: IHtmlString

Inherited Members WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ToComponent()WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.Name(string)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.Deferred(bool)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ModelMetadata(ModelMetadata)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.HtmlAttributes(object)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.HtmlAttributes(IDictionary<string, object>)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.AsModule(bool)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.Render()WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ScriptAttributes(object, bool)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ScriptAttributes(IDictionary<string, object>, bool)WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ToHtmlString()WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ToClientTemplate()WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.ToString()WidgetBuilderBase<PivotGrid<TModel>, PivotGridBuilder<TModel>>.Componentobject.GetType()object.MemberwiseClone()object.ToString()object.Equals(object)object.Equals(object, object)object.ReferenceEquals(object, object)object.GetHashCode()...

Constructors

PivotGridBuilder(PivotGrid<TModel>)

Initializes a new instance of the PivotGridBuilder<TModel> class.

C#
public PivotGridBuilder(PivotGrid<TModel> component)
Parameters:componentPivotGrid<TModel>

The component.

Methods

AutoBind(bool)

If set to false the initial binding will be prevented.

C#
public PivotGridBuilder<TModel> AutoBind(bool autoBind)
Parameters:autoBindbool

The autoBind

Returns:

PivotGridBuilder<TModel>

BindTo(IEnumerable<TModel>)

Binds the pivotGrid to a list of objects

C#
public PivotGridBuilder<TModel> BindTo(IEnumerable<TModel> dataSource)
Parameters:dataSourceIEnumerable<TModel>

The data source.

Returns:

PivotGridBuilder<TModel>

ColumnHeaderTemplate(string)

Sets the column header cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> ColumnHeaderTemplate(string template)
Parameters:templatestring

The template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.ColumnHeaderTemplate("#: member.caption #")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

ColumnHeaderTemplateHandler(string)

Sets the JavaScript function that returns the column header template.

C#
public PivotGridBuilder<TModel> ColumnHeaderTemplateHandler(string template)
Parameters:templatestring

The JavaScript function name.

Returns:

PivotGridBuilder<TModel>

ColumnHeaderTemplateId(string)

Sets the column header cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> ColumnHeaderTemplateId(string templateId)
Parameters:templateIdstring

The template id

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.ColumnHeaderTemplateId("columnHeaderTemplateId")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

ColumnHeaderTemplateView(MvcHtmlString)

Sets the column header cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> ColumnHeaderTemplateView(MvcHtmlString template)
Parameters:templateMvcHtmlString

The view template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.ColumnHeaderTemplateView(Html.Partial("header-template"))
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

ColumnWidth(int)

Use it to set the column width of the Pivot.

C#
public PivotGridBuilder<TModel> ColumnWidth(int columnWidth)
Parameters:columnWidthint

The column width.

Returns:

PivotGridBuilder<TModel>

Configurator(string)

Use it to set the Id of the PivotConfigurator.

C#
public PivotGridBuilder<TModel> Configurator(string configurator)
Parameters:configuratorstring

The configurator

Returns:

PivotGridBuilder<TModel>

DataCellTemplate(string)

Sets the data cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> DataCellTemplate(string template)
Parameters:templatestring

The template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.DataCellTemplate("#: dataItem.fmtValue #")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

DataCellTemplateHandler(string)

Sets the JavaScript function that returns the data cell template.

C#
public PivotGridBuilder<TModel> DataCellTemplateHandler(string template)
Parameters:templatestring

The JavaScript function name.

Returns:

PivotGridBuilder<TModel>

DataCellTemplateId(string)

Sets the data cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> DataCellTemplateId(string templateId)
Parameters:templateIdstring

The template id

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.DataCellTemplateId("dataCellTemplateId")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

DataCellTemplateView(MvcHtmlString)

Sets the data cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> DataCellTemplateView(MvcHtmlString template)
Parameters:templateMvcHtmlString

The view template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.DataCellTemplateView(Html.Partial("data-cell-template"))
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

DataSource(Action<PivotDataSourceBuilder<TModel>>)

Sets the data source configuration of the grid.

C#
public PivotGridBuilder<TModel> DataSource(Action<PivotDataSourceBuilder<TModel>> configurator)
Parameters:configuratorAction<PivotDataSourceBuilder<TModel>>

The lambda which configures the data source

Returns:

PivotGridBuilder<TModel>

DataSource(string)

Sets the data source by specifying the ID of an existing data source component.

C#
public PivotGridBuilder<TModel> DataSource(string dataSourceId)
Parameters:dataSourceIdstring

The ID of the data source component.

Returns:

PivotGridBuilder<TModel>

Events(Action<PivotGridEventBuilder>)

Configures the client-side events

C#
public PivotGridBuilder<TModel> Events(Action<PivotGridEventBuilder> configurator)
Parameters:configuratorAction<PivotGridEventBuilder>Returns:

PivotGridBuilder<TModel>

Excel(Action<PivotGridExcelBuilder>)

Configures the Excel export settings.

C#
public PivotGridBuilder<TModel> Excel(Action<PivotGridExcelBuilder> configurator)
Parameters:configuratorAction<PivotGridExcelBuilder>Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.Excel(excel =&gt; excel.FileName("PivotGridExport.xlsx"))
)

Filterable(bool)

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

C#
public PivotGridBuilder<TModel> Filterable(bool filterable)
Parameters:filterablebool

The filterable

Returns:

PivotGridBuilder<TModel>

Height(int)

Use it to set the height of the Pivot.

C#
public PivotGridBuilder<TModel> Height(int height)
Parameters:heightint

The height

Returns:

PivotGridBuilder<TModel>

KPIStatusTemplate(string)

Sets the KPI Status template of the pivot grid.

C#
public PivotGridBuilder<TModel> KPIStatusTemplate(string template)
Parameters:templatestring

The template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.KPIStatusTemplate("#: dataItem.value #")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

KPIStatusTemplateHandler(string)

Sets the JavaScript function that returns the KPI Status template.

C#
public PivotGridBuilder<TModel> KPIStatusTemplateHandler(string template)
Parameters:templatestring

The JavaScript function name.

Returns:

PivotGridBuilder<TModel>

KPIStatusTemplateId(string)

Sets the KPI Status template of the pivot grid.

C#
public PivotGridBuilder<TModel> KPIStatusTemplateId(string templateId)
Parameters:templateIdstring

The template id

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.KPIStatusTemplateId("kpiStatusTemplateId")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

KPIStatusTemplateView(MvcHtmlString)

Sets the KPI Status template of the pivot grid.

C#
public PivotGridBuilder<TModel> KPIStatusTemplateView(MvcHtmlString template)
Parameters:templateMvcHtmlString

The view template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.KPIStatusTemplateView(Html.Partial("kpis-template"))
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

KPITrendTemplate(string)

Sets the KPI Trend template of the pivot grid.

C#
public PivotGridBuilder<TModel> KPITrendTemplate(string template)
Parameters:templatestring

The template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.KPITrendTemplate("#: dataItem.value #")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

KPITrendTemplateHandler(string)

Sets the JavaScript function that returns the KPI Trend template.

C#
public PivotGridBuilder<TModel> KPITrendTemplateHandler(string template)
Parameters:templatestring

The JavaScript function name.

Returns:

PivotGridBuilder<TModel>

KPITrendTemplateId(string)

Sets the KPI Trend template of the pivot grid.

C#
public PivotGridBuilder<TModel> KPITrendTemplateId(string templateId)
Parameters:templateIdstring

The template id

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.KPITrendTemplateId("kpiTrendTemplateId")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

KPITrendTemplateView(MvcHtmlString)

Sets the KPI Trend template of the pivot grid.

C#
public PivotGridBuilder<TModel> KPITrendTemplateView(MvcHtmlString template)
Parameters:templateMvcHtmlString

The template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.KPITrendTemplateView(Html.Partial("kpi-trend-template"))
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

Messages(Action<PivotGridMessagesBuilder>)

Sets the messages of the pivotGrid.

C#
public PivotGridBuilder<TModel> Messages(Action<PivotGridMessagesBuilder> addViewAction)
Parameters:addViewActionAction<PivotGridMessagesBuilder>

The lambda which configures the pivotGrid messages

Returns:

PivotGridBuilder<TModel>

Pdf(Action<PDFSettingsBuilder>)

Configures the PDF export settings.

C#
public PivotGridBuilder<TModel> Pdf(Action<PDFSettingsBuilder> configurator)
Parameters:configuratorAction<PDFSettingsBuilder>Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.Pdf(pdf =&gt; pdf.FileName("PivotGridExport.pdf"))
)

Reorderable(bool)

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

C#
public PivotGridBuilder<TModel> Reorderable(bool reorderable)
Parameters:reorderablebool

The reorderable

Returns:

PivotGridBuilder<TModel>

RowHeaderTemplate(string)

Sets the row header cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> RowHeaderTemplate(string template)
Parameters:templatestring

The template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.RowHeaderTemplate("#: member.caption #")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

RowHeaderTemplateHandler(string)

Sets the JavaScript function that returns the row header template.

C#
public PivotGridBuilder<TModel> RowHeaderTemplateHandler(string template)
Parameters:templatestring

The JavaScript function name.

Returns:

PivotGridBuilder<TModel>

RowHeaderTemplateId(string)

Sets the row header cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> RowHeaderTemplateId(string templateId)
Parameters:templateIdstring

The template id

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.RowHeaderTemplateId("rowHeaderTemplateId")
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

RowHeaderTemplateView(MvcHtmlString)

Sets the row header cell template of the pivot grid.

C#
public PivotGridBuilder<TModel> RowHeaderTemplateView(MvcHtmlString template)
Parameters:templateMvcHtmlString

The view template

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.RowHeaderTemplateView(Html.Partial("header-template"))
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

Sortable()

Enables grid column sorting.

C#
public PivotGridBuilder<TModel> Sortable()
Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.Sortable()
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)

Sortable(Action<PivotGridSortSettingsBuilder>)

Sets the sorting configuration of the pivotgrid.

C#
public PivotGridBuilder<TModel> Sortable(Action<PivotGridSortSettingsBuilder> configurator)
Parameters:configuratorAction<PivotGridSortSettingsBuilder>

The lambda which configures the sorting

Returns:

PivotGridBuilder<TModel>

Example:
C#
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.Sortable(sorting =&gt; sorting.AllowUnsort(true))
.DataSource(dataSource =&gt;
dataSource.Xmla()
.Columns(columns =&gt; columns.Add("[Date].[Calendar]").Expand(true))
.Rows(rows =&gt; rows.Add("[Geography].[City]"))
.Measures(measures =&gt; measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport =&gt; transport
.Connection(connection =&gt; connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read =&gt; read
.Url("http://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)
In this article
DefinitionConstructorsPivotGridBuilder(PivotGrid<TModel>)MethodsAutoBind(bool)BindTo(IEnumerable<TModel>)ColumnHeaderTemplate(string)ColumnHeaderTemplateHandler(string)ColumnHeaderTemplateId(string)ColumnHeaderTemplateView(MvcHtmlString)ColumnWidth(int)Configurator(string)DataCellTemplate(string)DataCellTemplateHandler(string)DataCellTemplateId(string)DataCellTemplateView(MvcHtmlString)DataSource(Action<PivotDataSourceBuilder<TModel>>)DataSource(string)Events(Action<PivotGridEventBuilder>)Excel(Action<PivotGridExcelBuilder>)Filterable(bool)Height(int)KPIStatusTemplate(string)KPIStatusTemplateHandler(string)KPIStatusTemplateId(string)KPIStatusTemplateView(MvcHtmlString)KPITrendTemplate(string)KPITrendTemplateHandler(string)KPITrendTemplateId(string)KPITrendTemplateView(MvcHtmlString)Messages(Action<PivotGridMessagesBuilder>)Pdf(Action<PDFSettingsBuilder>)Reorderable(bool)RowHeaderTemplate(string)RowHeaderTemplateHandler(string)RowHeaderTemplateId(string)RowHeaderTemplateView(MvcHtmlString)Sortable()Sortable(Action<PivotGridSortSettingsBuilder>)
Not finding the help you need?
Contact Support