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