kendoPivotGridV2
Namespace: Wisej.Web.Ext.Kendo
Assembly: Wisej.Web.Ext.Kendo (4.1.0.0)
Like its original version, the Kendo UI PivotGridV2 represents multidimensional data in a cross-tabular format.
- C#
- VB.NET
public class kendoPivotGridV2 : kendoBase
Public Class kendoPivotGridV2
Inherits kendoBase
Compared to the legacy PivotGrid, the new PivotGridV2 offers a brand new design, and its future-proof architecture allows the implementation of many upcoming functionalities.
Constructors
kendoPivotGridV2()
Constructs a new instance of the kendoPivotGridV2 class.
Example:
The following example creates a pivot grid and connects it to an OLAP cube through the Options property.
var pivot = new kendoPivotGridV2();
pivot.Options.columnWidth = 140;
pivot.Options.dataSource = new
{
type = "xmla",
columns = new[] { new { name = new[] { "[Date].[Calendar]" }, expand = true } },
rows = new[] { new { name = new[] { "[Geography].[City]" }, expand = true } },
measures = new[] { new { name = 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"
}
};
pivot.Dock = DockStyle.Fill;
this.Controls.Add(pivot);
kendoPivotGridV2(options)
Constructs a new instance of the kendoPivotGridV2 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, with two dimensions on the column axis.
var pivot = new kendoPivotGridV2(new
{
columnWidth = 120,
dataSource = new
{
type = "xmla",
columns = new object[]
{
new { name = new[] { "[Date].[Calendar]" }, expand = true },
new { name = new[] { "[Product].[Category]" } }
},
rows = new[] { new { name = new[] { "[Geography].[City]" }, expand = true } },
measures = new[] { new { name = 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"
}
}
});
pivot.Dock = DockStyle.Fill;
this.Controls.Add(pivot);