ASP.NET MVC PivotGrid Overview
The PivotGrid is part of Telerik UI for ASP.NET MVC, a
professional grade UI library with 110+ components for building modern and feature-rich applications. To try it out sign up for a free 30-day trial.
The Telerik UI PivotGrid HtmlHelper for ASP.NET MVC is a server-side wrapper for the Kendo UI PivotGrid widget.
The PivotGrid represents multidimensional data in a cross-tabular format.
Basic Configuration
To configure the PivotGrid for Ajax binding to an Adventure Works cube that is hosted on https://demos.telerik.com/olap/msmdpump.dll:
- Create a new ASP.NET MVC application. If you have the Telerik UI for ASP.NET MVC Visual Studio Extensions installed, create a Telerik UI for ASP.NET MVC application. Name the application
KendoPivotGrid. If you decide not to use the Telerik UI for ASP.NET MVC Visual Studio Extensions, follow the steps from the introductory article to add Telerik UI for ASP.NET MVC to the application. - Add a PivotGrid to the
Indexview.
@(Html.Kendo().PivotGrid()
.Name("pivotgrid")
.DataSource(dataSource => dataSource.
Xmla()
.Columns(columns => {
columns.Add("[Date].[Calendar]").Expand(true);
columns.Add("[Geography].[City]");
})
.Rows(rows => rows.Add("[Product].[Product]"))
.Measures(measures => measures.Values(new string[]{"[Measures].[Internet Sales Amount]"}))
.Transport(transport => transport
.Connection(connection => connection
.Catalog("Adventure Works DW 2008R2")
.Cube("Adventure Works"))
.Read(read => read
.Url("https://demos.telerik.com/olap/msmdpump.dll")
.DataType("text")
.ContentType("text/xml")
.Type(HttpVerbs.Post)
)
)
)
)
- Build and run the application.
Functionality and Features
Referencing Existing Instances
To reference an existing PivotGrid instance, use the jQuery.data() method. Once a reference is established, use the PivotGrid client-side API to control its behavior.
var pivotgrid = $("#pivotgrid").data("kendoPivotGrid");