Articles in this section
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

 

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied