kendoPivotGrid
Namespace: Wisej.Web.Ext.Kendo
Assembly: Wisej.Web.Ext.Kendo (4.1.0.0)
The Kendo UI PivotGrid represents multidimensional data in a cross-tabular format.
- C#
- VB.NET
public class kendoPivotGrid : kendoBase
Public Class kendoPivotGrid
Inherits kendoBase
Constructors
kendoPivotGrid()
Constructs a new instance of the kendoPivotGrid class.
Example:
The following example creates a pivot grid and binds it to an in-memory list through the Options property.
var pivot = new kendoPivotGrid();
pivot.Options.columnWidth = 120;
pivot.Options.dataSource = new
{
data = sales,
schema = new
{
cube = new
{
dimensions = new
{
category = new { caption = "All categories" },
region = new { caption = "All regions" }
},
measures = new
{
Total = new { field = "amount", aggregate = "sum" }
}
}
},
columns = new[] { new { name = "category", expand = true } },
rows = new[] { new { name = "region", expand = true } },
measures = new[] { "Total" }
};
pivot.Dock = DockStyle.Fill;
this.Controls.Add(pivot);
kendoPivotGrid(options)
Constructs a new instance of the kendoPivotGrid class.
| Name | Type | Description |
|---|---|---|
| options | Object | Initial set of options. |
Example:
The following example creates a pivot grid connected to an OLAP cube through XMLA.
var pivot = new kendoPivotGrid(new
{
filterable = true,
sortable = true,
columnWidth = 120,
dataSource = new
{
type = "xmla",
columns = new[] { new { name = "[Date].[Calendar]", expand = true } },
rows = new[] { new { name = "[Geography].[City]" } },
measures = new[] { "[Measures].[Reseller Freight Cost]" },
transport = new
{
connection = new { catalog = "Adventure Works DW 2008R2", cube = "Adventure Works" },
read = "https://demos.telerik.com/olap/msmdpump.dll"
},
schema = new { type = "xmla" }
}
});
pivot.Dock = DockStyle.Fill;
this.Controls.Add(pivot);