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.

Download Free 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.

• Demo page for the PivotGrid HtmlHelper

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, follow the next steps:

1. 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.

2. Add a PivotGrid to the Index View.

       @(Html.Kendo().PivotConfigurator()
           .Name("configurator")
           .Filterable(true)
           .Sortable()
           .Height(570)
       )
   
       @(Html.Kendo().PivotGrid()
           .Name("pivotgrid")
           .ColumnWidth(200)
           .Height(570)
           .Filterable(true)
           .Sortable()
           .Configurator("#configurator")
           .DataSource(dataSource => dataSource.
               Xmla()
               .Columns(columns => {
                   columns.Add("[Date].[Calendar]").Expand(true);
                   columns.Add("[Product].[Category]");
               })
               .Rows(rows => rows.Add("[Geography].[City]"))
               .Measures(measures => measures.Values(new string[]{"[Measures].[Reseller Freight Cost]"}))
               .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)
                   )
               )
           )
       )
   

3. Build and run the application.

Functionality and Features

• Data binding—You can bind the PivotGrid to Online Analytical Processing (OLAP) cube and or flat data.
• Filtering—Enable the filtering of the PivotGrid rows and columns.
• Sorting—The component supports sorting by the caption name of the members.
• Templates—The available templates allow you to control the rendering of the data cells and headers.
• Excel export—The PivotGrid provides an export to Excel feature.
• PDF export—You can export the PivotGrid content to PDF through a single click.

Next Steps

• Getting Started with the PivotGrid
• Basic Usage of the PivotGrid HtmlHelper for ASP.NET MVC (Demo)

See Also

• Server-Side API of the PivotGrid HtmlHelper

• Client-Side API of the PivotGrid