Category / Section
How to manipulate or iterate PivotGrid cells in server-side?
1 min read
This KB illustrates that how to iterate cells at PivotGrid server-side.
Solution:
You can manipulate or iterate PivotGrid cells in server-side by using the following code examples.
C#
public Dictionary<string, object> InitializeGrid(string action, string gridLayout, bool enablePivotFieldList, object customObject) { //Other codes here. OlapDataManager dataManager = new OlapDataManager(connectionString); dataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(olapReport)); var InilizeJsonData = new OlapClient().GetJsonData(action, dataManager, pivotGridlayout); var PivotGridCell = new PivotCellDescriptor(); if (dataManager.PivotEngine != null) pivotGridCell = dataManager.PivotEngine.TableColumns[0].Cells[0];//Here PivotGrid cells can be manipulated/iterated. return InilizeJsonData; }
VB
Public Function InitializeGrid(ByVal action As String, ByVal gridLayout As String, ByVal enablePivotFieldList As Boolean, ByVal customObject As Object) As Dictionary(Of String, Object) 'Other codes here. Dim dataManager As OlapDataManager = New OlapDataManager(connectionString) dataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(olapReport)) Dim InilizeJsonData = New OlapClient().GetJsonData(action, dataManager, pivotGridlayout) Dim PivotGridCell = New PivotCellDescriptor() If dataManager.PivotEngine IsNot Nothing Then pivotGridCell = dataManager.PivotEngine.TableColumns(0).Cells(0) 'Here PivotGrid cells can be manipulated/iterated. If Return InilizeJsonData End Function