ejPivotGrid
Namespace: Wisej.Web.Ext.Syncfusion
Assembly: Wisej.Web.Ext.Syncfusion (4.1.0.0)
PivotGrid control is an easily configurable and presentation-quality business control. It reads both OLAP and relational datasources, and allows to create multi-dimensional views for analyzing and satisfying the needs of business user.
- C#
- VB.NET
public class ejPivotGrid : ejBase
Public Class ejPivotGrid
Inherits ejBase
Constructors
ejPivotGrid()
Constructs a new instance of the ejPivotGrid class.
Example:
The following example creates the pivot grid and defines the relational data source through the options.
var pivotGrid = new ejPivotGrid();
pivotGrid.Options.dataSource = new
{
data = sales,
rows = new[] { new { fieldName = "Country" } },
columns = new[] { new { fieldName = "Product" } },
values = new[] { new { fieldName = "Amount" } }
};
pivotGrid.Dock = DockStyle.Fill;
this.Controls.Add(pivotGrid);
ejPivotGrid(options)
Constructs a new instance of the ejPivotGrid class.
| Name | Type | Description |
|---|---|---|
| options | Object | Initial set of options. |
Example:
The following example creates a pivot grid with the grouping bar that summarizes the amount by country, state and product.
var pivotGrid = new ejPivotGrid(new
{
dataSource = new
{
data = sales,
rows = new[]
{
new { fieldName = "Country", fieldCaption = "Country" },
new { fieldName = "State", fieldCaption = "State" }
},
columns = new[] { new { fieldName = "Product", fieldCaption = "Product" } },
values = new[] { new { fieldName = "Amount", fieldCaption = "Amount" } }
},
enableGroupingBar = true
});
pivotGrid.Dock = DockStyle.Fill;
this.Controls.Add(pivotGrid);