ejPivotClient
Namespace: Wisej.Web.Ext.Syncfusion
Assembly: Wisej.Web.Ext.Syncfusion (4.1.0.0)
The pivot client control for the Essential JavaScript provides support to bind both the OLAP and relational data sources. You can visualize the results in graphical and tabular formats (chart and grid). The pivot client control is also used to create and edit a report on-the-fly that is stored for later use.
- C#
- VB.NET
public class ejPivotClient : ejBase
Public Class ejPivotClient
Inherits ejBase
The wrapper always sets the isResponsive option of the widget to true and the url option to the service URL of this control, replacing the values specified in the options. The requests sent by the widget to its service are therefore sent to this control and are received by the application through the WebRequest event.
Constructors
ejPivotClient()
Constructs a new instance of the ejPivotClient class.
Example:
The following example creates the pivot client and defines the relational data source through the options.
var pivotClient = new ejPivotClient();
pivotClient.Options.title = "Sales analysis";
pivotClient.Options.dataSource = new
{
data = sales,
rows = new[] { new { fieldName = "Country" } },
columns = new[] { new { fieldName = "Product" } },
values = new[] { new { fieldName = "Amount" } }
};
pivotClient.Dock = DockStyle.Fill;
this.Controls.Add(pivotClient);
ejPivotClient(options)
Constructs a new instance of the ejPivotClient class.
| Name | Type | Description |
|---|---|---|
| options | Object | Initial set of options. |
Example:
The following example creates a pivot client that analyzes the amount and the quantity by country and product.
var pivotClient = new ejPivotClient(new
{
title = "Sales analysis",
dataSource = new
{
data = sales,
rows = new[] { new { fieldName = "Country", fieldCaption = "Country" } },
columns = new[] { new { fieldName = "Product", fieldCaption = "Product" } },
values = new[]
{
new { fieldName = "Amount", fieldCaption = "Amount" },
new { fieldName = "Quantity", fieldCaption = "Quantity" }
}
}
});
pivotClient.Dock = DockStyle.Fill;
this.Controls.Add(pivotClient);