Hierarchy Grids, have the change function in the detailed(sub) grid update a column on the main table.

[Andrew]

I have a total score field in the master table that I need to update from the detail(sub) table. 

I think this would be achieved in the detailed(sub) table, every change I calculate the full total score and need to update the row that the sub table belongs to. I tried the set command on the top object , but it hasn't worked for me yet. 

Any ideas would be appreciated?

Thanks

-Andrew

[Andrew]

I figured out how to set the data in the master from the child BUT, the
whole table collapses the child grids when anything is updated, this is a
very annoying behavior, is there anyway I can just update a field in
the master table without it collapsing all the child elements?
(basically, update the column, no mass table update)

[Alexander Valchev]

Hi Andrew,

I am afraid that this behaviour cannot be prevented. When data changes, DataSource will throw its change event which will force the Grid to rebind. As a result the detail rows will collapse.

One possible workaround is to remember expanded child elements and reopen them at dataBound of the Grid.
Similar approach is used in this demo.

dataBound: function() {
    this.expandRow(this.tbody.find("tr.k-master-row").first());
},

Refreshing a single column or row is not supported.

Kind regards,
Alexander Valchev
the Telerik team

[jon]

I just need to add my two cents. This is such a common requirement, and the solution here is an absolute hack. I don't believe this work-around is a good solution.

[Kiril Nikolov]

Hi Jon,

I am afraid that at the moment this is the only solution available, as the grid rebind on data change cannot be prevented. I think that saving the expanded row and then expand it again on dataBound is the most viable workaround that can be offered at the moment.

Regards,
Kiril Nikolov
Telerik