Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
40
Get a cell value from a second/third/... band of a hierarchical grid
posted

Hi guys

 

Sorry if I raise a very commonly asked question, but I spent the whole day searching the net and your forums and still found nothing on my issue.

I have a three-level hierarchical grid (UltraGrid), I need to get cell values from the second and third grid bands.

 

I can fetch the data from the first level grid without any issues, but when I need to go one or two levels deeper, it gets rather tricky.

 

Could you give me an example how do one fetches data from hierarchical grids over the multiple layers, please?

Parents
No Data
Reply
  • 9298
    Verified Answer
    posted

    Eugene,

    MsgBox SwfWindow("Form1").SwfTable("ultraGrid1").GetCellData("0;0;2","Quantity")

    In a case where you have a grid with three levels this code would display the value in the "Quantity" column of the third row in the first child row of the first row in the grid.  In other words, the third row of Band[2] in the grid.

Children