Class PivotGrid
Inheritance
System.Object
PivotGrid
Implements
System.Web.IHtmlString
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Assembly: Syncfusion.EJ.Pivot.dll
Syntax
public class PivotGrid : Control, IHtmlString
Constructors
PivotGrid()
Declaration
PivotGrid(String, PivotGridProperties)
Declaration
public PivotGrid(string id, PivotGridProperties propModel)
Parameters
Fields
PivotEngine
Declaration
public PivotEngine PivotEngine
Field Value
| Type |
Description |
| Syncfusion.PivotAnalysis.Base.PivotEngine |
|
Properties
Model
Declaration
protected override object Model { get; }
Property Value
| Type |
Description |
| System.Object |
|
Overrides
PivotGridModel
Declaration
public PivotGridProperties PivotGridModel { get; set; }
Property Value
PivotReport
Declaration
public PivotReport PivotReport { get; set; }
Property Value
PluginName
Declaration
public override string PluginName { get; }
Property Value
| Type |
Description |
| System.String |
|
Overrides
TagName
Declaration
public override string TagName { get; }
Property Value
| Type |
Description |
| System.String |
|
Overrides
Methods
ApplyValueSorting(Dictionary<String, Object>, String)
Declaration
public Dictionary<string, object> ApplyValueSorting(Dictionary<string, object> dict, string sortedHeaders)
Parameters
| Type |
Name |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
dict |
|
| System.String |
sortedHeaders |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
CreateContainer(String)
Declaration
public override HtmlString CreateContainer(string controlId)
Parameters
| Type |
Name |
Description |
| System.String |
controlId |
|
Returns
| Type |
Description |
| System.Web.HtmlString |
|
Overrides
DeserializedReports(String)
Declaration
public PivotReport DeserializedReports(string reports)
Parameters
| Type |
Name |
Description |
| System.String |
reports |
|
Returns
DrillthroughDataTable(PivotGridHelper)
Declaration
public PivotGridArgs DrillthroughDataTable(PivotGridHelper helper)
Parameters
Returns
DrillthroughDataTable(OlapDataManager, String, String, String)
Declaration
public Dictionary<string, object> DrillthroughDataTable(OlapDataManager dataManager, string gridLayout, string cellPosition, string selector)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
dataManager |
|
| System.String |
gridLayout |
|
| System.String |
cellPosition |
|
| System.String |
selector |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
DrillthroughHierarchies(PivotGridHelper)
Declaration
public string DrillthroughHierarchies(PivotGridHelper helper)
Parameters
Returns
| Type |
Description |
| System.String |
|
DrillthroughHierarchies(OlapDataManager, String, String)
Declaration
public string DrillthroughHierarchies(OlapDataManager dataManager, string gridLayout, string cellPosition)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
dataManager |
|
| System.String |
gridLayout |
|
| System.String |
cellPosition |
|
Returns
| Type |
Description |
| System.String |
|
ExportPivotGrid(OlapDataManager, String, String, HttpResponse)
Declaration
public void ExportPivotGrid(OlapDataManager DataManager, string args, string fileName, HttpResponse response)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
args |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
ExportPivotGrid(Object, String, String, HttpResponse)
Declaration
public void ExportPivotGrid(object dataSource, string args, string fileName, HttpResponse response)
Parameters
| Type |
Name |
Description |
| System.Object |
dataSource |
|
| System.String |
args |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
ExportToExcel(OlapDataManager, String, String, HttpResponse)
Declaration
public void ExportToExcel(OlapDataManager DataManager, string args, string fileName, HttpResponse response)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
args |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
ExportToExcel(IWorkbook, OlapDataManager, String, HttpResponse, Color, Color, Color, Color)
Declaration
public void ExportToExcel(IWorkbook workbook, OlapDataManager DataManager, string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
Parameters
| Type |
Name |
Description |
| IWorkbook |
workbook |
|
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
| System.Drawing.Color |
valueCellColor |
|
| System.Drawing.Color |
valueCellBGColor |
|
| System.Drawing.Color |
summaryCellColor |
|
| System.Drawing.Color |
summaryCellBGColor |
|
ExportToExcel(String, HttpResponse, Color, Color, Color, Color)
Declaration
public void ExportToExcel(string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
Parameters
| Type |
Name |
Description |
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
| System.Drawing.Color |
valueCellColor |
|
| System.Drawing.Color |
valueCellBGColor |
|
| System.Drawing.Color |
summaryCellColor |
|
| System.Drawing.Color |
summaryCellBGColor |
|
ExportToPdf(PdfDocument, OlapDataManager, String, HttpResponse, Color, Color, Color, Color)
Declaration
public void ExportToPdf(PdfDocument pdfDoc, OlapDataManager DataManager, string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
Parameters
| Type |
Name |
Description |
| PdfDocument |
pdfDoc |
|
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
| System.Drawing.Color |
valueCellColor |
|
| System.Drawing.Color |
valueCellBGColor |
|
| System.Drawing.Color |
summaryCellColor |
|
| System.Drawing.Color |
summaryCellBGColor |
|
ExportToPdf(String, HttpResponse, Color, Color, Color, Color)
Declaration
public void ExportToPdf(string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
Parameters
| Type |
Name |
Description |
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
| System.Drawing.Color |
valueCellColor |
|
| System.Drawing.Color |
valueCellBGColor |
|
| System.Drawing.Color |
summaryCellColor |
|
| System.Drawing.Color |
summaryCellBGColor |
|
ExportToWord(WordDocument, OlapDataManager, String, HttpResponse, Color, Color, Color, Color)
Declaration
public void ExportToWord(WordDocument document, OlapDataManager DataManager, string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
Parameters
| Type |
Name |
Description |
| WordDocument |
document |
|
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
| System.Drawing.Color |
valueCellColor |
|
| System.Drawing.Color |
valueCellBGColor |
|
| System.Drawing.Color |
summaryCellColor |
|
| System.Drawing.Color |
summaryCellBGColor |
|
ExportToWord(String, HttpResponse, Color, Color, Color, Color)
Declaration
public void ExportToWord(string fileName, HttpResponse response, Color valueCellColor, Color valueCellBGColor, Color summaryCellColor, Color summaryCellBGColor)
Parameters
| Type |
Name |
Description |
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
| System.Drawing.Color |
valueCellColor |
|
| System.Drawing.Color |
valueCellBGColor |
|
| System.Drawing.Color |
summaryCellColor |
|
| System.Drawing.Color |
summaryCellBGColor |
|
ExportToXml(String, String, HttpResponse)
Declaration
public void ExportToXml(string clientReport, string fileName, HttpResponse response)
Parameters
| Type |
Name |
Description |
| System.String |
clientReport |
|
| System.String |
fileName |
|
| System.Web.HttpResponse |
response |
|
FindEditorTreeInfo(OlapDataManager, String)
Declaration
public List<object> FindEditorTreeInfo(OlapDataManager manager, string dimensionName)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
manager |
|
| System.String |
dimensionName |
|
Returns
| Type |
Description |
| System.Collections.Generic.List<System.Object> |
|
GenerateJSONData(PivotReport, PivotEngine)
Declaration
public string GenerateJSONData(PivotReport pivotReport, PivotEngine pivotCellInfos)
Parameters
| Type |
Name |
Description |
| PivotReport |
pivotReport |
|
| Syncfusion.PivotAnalysis.Base.PivotEngine |
pivotCellInfos |
|
Returns
| Type |
Description |
| System.String |
|
GenerateJSONData(OlapDataManager, String)
Declaration
public string GenerateJSONData(OlapDataManager DataManager, string gridLayout)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
gridLayout |
|
Returns
| Type |
Description |
| System.String |
|
GenerateJSONData(PivotEngine)
Declaration
public string GenerateJSONData(PivotEngine pivotCellInfos)
Parameters
| Type |
Name |
Description |
| Syncfusion.PivotAnalysis.Base.PivotEngine |
pivotCellInfos |
|
Returns
| Type |
Description |
| System.String |
|
GetDependentControl()
Declaration
protected override List<string> GetDependentControl()
Returns
| Type |
Description |
| System.Collections.Generic.List<System.String> |
|
Overrides
GetJsonData(PivotGridHelper)
Declaration
public PivotGridArgs GetJsonData(PivotGridHelper helper)
Parameters
Returns
GetJsonData(PivotReport, Object)
Declaration
public Dictionary<string, object> GetJsonData(PivotReport report, object dataSource)
Parameters
| Type |
Name |
Description |
| PivotReport |
report |
|
| System.Object |
dataSource |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, Boolean, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager dataManager, bool checkedStatus, string parentNode, string tag, string headerInfo)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
dataManager |
|
| System.Boolean |
checkedStatus |
|
| System.String |
parentNode |
|
| System.String |
tag |
|
| System.String |
headerInfo |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string gridLayout)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
gridLayout |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, String, Boolean)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string gridLayout, bool enablePivotFieldList)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
gridLayout |
|
| System.Boolean |
enablePivotFieldList |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string cellPostion, string headerInfo)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
cellPostion |
|
| System.String |
headerInfo |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string value, string rowInfo, string columnInfo)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
value |
|
| System.String |
rowInfo |
|
| System.String |
columnInfo |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, String, String, String, Boolean)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string dropType, string nodeInfo, string filterParams, bool enablePivotFieldList)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
dropType |
|
| System.String |
nodeInfo |
|
| System.String |
filterParams |
|
| System.Boolean |
enablePivotFieldList |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, OlapDataManager, String, String, String, String, Boolean)
Declaration
public Dictionary<string, object> GetJsonData(string action, OlapDataManager datamanager, string dropType, string nodeInfo, string filterParams, string gridLayout, bool enablePivotFieldList)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
dropType |
|
| System.String |
nodeInfo |
|
| System.String |
filterParams |
|
| System.String |
gridLayout |
|
| System.Boolean |
enablePivotFieldList |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource, string sortedHeaders)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
| System.String |
sortedHeaders |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource, string cellPosition, string headerInfo)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
| System.String |
cellPosition |
|
| System.String |
headerInfo |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource, string state, string fieldHeader, string sortedHeaders)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
| System.String |
state |
|
| System.String |
fieldHeader |
|
| System.String |
sortedHeaders |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object, String, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource, string state, string fieldHeader, string filterParams, string sortedHeaders)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
| System.String |
state |
|
| System.String |
fieldHeader |
|
| System.String |
filterParams |
|
| System.String |
sortedHeaders |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object, String, String, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource, string gridLayout, string cellPosition, string headerInfo, string sortedHeaders, string filterParams)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
| System.String |
gridLayout |
|
| System.String |
cellPosition |
|
| System.String |
headerInfo |
|
| System.String |
sortedHeaders |
|
| System.String |
filterParams |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, Object, String, String, String, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, object dataSource, string gridLayout, string cellPosition, string headerInfo, string sortedHeaders, string filterParams, string valueSort)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.Object |
dataSource |
|
| System.String |
gridLayout |
|
| System.String |
cellPosition |
|
| System.String |
headerInfo |
|
| System.String |
sortedHeaders |
|
| System.String |
filterParams |
|
| System.String |
valueSort |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetJsonData(String, String, OlapDataManager, String, String, String)
Declaration
public Dictionary<string, object> GetJsonData(string action, string connectionString, OlapDataManager datamanager, string cellPostion, string headerInfo, string gridLayout)
Parameters
| Type |
Name |
Description |
| System.String |
action |
|
| System.String |
connectionString |
|
| Syncfusion.Olap.Manager.OlapDataManager |
datamanager |
|
| System.String |
cellPostion |
|
| System.String |
headerInfo |
|
| System.String |
gridLayout |
|
Returns
| Type |
Description |
| System.Collections.Generic.Dictionary<System.String, System.Object> |
|
GetLayoutProperties(String)
Declaration
public GridLayout GetLayoutProperties(string gridLayout)
Parameters
| Type |
Name |
Description |
| System.String |
gridLayout |
|
Returns
| Type |
Description |
| Syncfusion.Olap.Engine.GridLayout |
|
ImportFromXml(String)
Declaration
public void ImportFromXml(string xmlString)
Parameters
| Type |
Name |
Description |
| System.String |
xmlString |
|
OnElementDropped(OlapDataManager, String, String)
Declaration
public OlapDataManager OnElementDropped(OlapDataManager dataManager, string eventArgument, string droppedElement)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
dataManager |
|
| System.String |
eventArgument |
|
| System.String |
droppedElement |
|
Returns
| Type |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
|
OnFetchMembers(String, String)
Declaration
public FilterItemsCollection OnFetchMembers(string headerInfo, string cellPosition)
Parameters
| Type |
Name |
Description |
| System.String |
headerInfo |
|
| System.String |
cellPosition |
|
Returns
| Type |
Description |
| Syncfusion.PivotAnalysis.Base.FilterItemsCollection |
|
OnFilterElement(OlapDataManager, String)
Declaration
public OlapDataManager OnFilterElement(OlapDataManager DataManager, string clientParams)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
clientParams |
|
Returns
| Type |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
|
OnFiltering(String, String)
Declaration
public void OnFiltering(string headerInfo, string cellPosition)
Parameters
| Type |
Name |
Description |
| System.String |
headerInfo |
|
| System.String |
cellPosition |
|
Declaration
public OlapDataManager OnSplitButtonRemove(OlapDataManager DataManager, string clientParams)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
clientParams |
|
Returns
| Type |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
|
PopulateData(String)
Declaration
public void PopulateData(string report)
Parameters
| Type |
Name |
Description |
| System.String |
report |
|
RenderControl(String)
Declaration
public override void RenderControl(string controlId)
Parameters
| Type |
Name |
Description |
| System.String |
controlId |
|
Overrides
ReportManipulations(OlapDataManager, String, String)
Declaration
public OlapDataManager ReportManipulations(OlapDataManager DataManager, string reportName, string operationName)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
reportName |
|
| System.String |
operationName |
|
Returns
| Type |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
|
SetPaging(String, String)
Declaration
public OlapReport SetPaging(string currentReport, string pagingInfo)
Parameters
| Type |
Name |
Description |
| System.String |
currentReport |
|
| System.String |
pagingInfo |
|
Returns
| Type |
Description |
| Syncfusion.Olap.Reports.OlapReport |
|
UpdateDrilledReport(OlapDataManager, String)
Declaration
public void UpdateDrilledReport(OlapDataManager DataManager, string HeaderInfo)
Parameters
| Type |
Name |
Description |
| Syncfusion.Olap.Manager.OlapDataManager |
DataManager |
|
| System.String |
HeaderInfo |
|
Events
Declaration
public event PivotGrid.PDFHeaderFooterEventHandler AddPDFHeaderFooter
Event Type
CSVExport
Declaration
public event PivotGrid.CSVExportEventHandler CSVExport
Event Type
ExcelExport
Declaration
public event PivotGrid.ExcelExportEventHandler ExcelExport
Event Type
PDFExport
Declaration
public event PivotGrid.PDFExportEventHandler PDFExport
Event Type
PDFGridExporting
Declaration
public event PivotGrid.PDFGridExportingEventHandler PDFGridExporting
Event Type
WordExport
Declaration
public event PivotGrid.WordExportEventHandler WordExport
Event Type
Implements
System.Web.IHtmlString