Hi

I have a ultrawingrid with two bands  parent(band0) and child(band1) and i want to sum the child band payment column summary, to  parent band payment column.

i am having data relation between parent and child

eg:

in, parent band- first row have

 Party1, Payment columns

Child band - first row for Party1

Invoice1, Payment1 columns

Child band - second row for Party1

Invoice2, Payment2 columns.

need to sum child band payment1+payment2 values and added to payment column in parent band for Party1.

similarly for Party2..

Could you help me on this process?

Yes. To refer to an individual cell in a grid, you use the band name and index the row, then specify the column.

So, for example, to sum the first cell in two different grids, the formula would look something like this:

[//ultraGrid1/Band 0(0)/Column 0] +  [//ultraGrid2/Band 0(0)/Column 0]

Is it possible the Sum Cell from 2 diff Grid.

Hi Mike,

I try with 

e.Row.ExpandAll(); 

In the AfterRowInsert Event and work`s fine, whe I press the Tab key in the last cell of the Parent Band got the focus in the new row of the chid band.

Thanks for your time,

Alejandro Castrejon

Hi Alejandro, 

I'm not sure if that will be an easy thing to do. AfterRowUpdate makes sense and you could check if the row being update IsAddRow, so you will be able to tell if it's a new row being added or an existing row being updated.

But from a UI perspective, putting focus on the child row doesn't seem like a good idea. What if the user adds a new row and then enters some values into it and then clicks on some other control on the form or some other row in the grid? Do you really want to force focus back into the child row cell in that case?