New to Telerik UI for ASP.NET MVC? Download free 30-day trial

PivotDataSourceBuilder

Methods

Xmla()

Configures the DataSource of the PivotGrid component for Xmla binding.

Example


            @(Html.Kendo().PivotGrid()
               .Name("pivotgrid")
               ...
               .DataSource(dataSource => dataSource.
                   Xmla()
                   .Columns(columns => {
                       columns.Add("[Date].[Calendar]").Expand(true);
                   })
                   .Rows(rows => rows.Add("[Geography].[City]"))
                   .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)
                       )
                   )
               )
            )

Custom()

Configures the DataSource of the PivotGrid component for custom binding.

Example


            @(Html.Kendo().PivotGrid()
               .Name("pivotgrid")
               ...
               .DataSource(dataSource => dataSource
                .Custom()
                 ...
                )
            )

Ajax()

Configures the DataSource of the PivotGrid component for Ajax binding to flat data.

Example


            @(Html.Kendo().PivotGrid()
               .Name("pivotgrid")
               ...
               .DataSource(dataSource => dataSource
                .Ajax()
                 ...
                )
            )

In this article
Not finding the help you need?