Hi everyone,
my problem is a little bit strange. You can see my problem in the picture. I have two table, station and data. I want to get result only root station data but root station data is sum of child station data. How can I do easly? Please help me... I use Telerik Rad AJAX 2009 Q3.
my problem is a little bit strange. You can see my problem in the picture. I have two table, station and data. I want to get result only root station data but root station data is sum of child station data. How can I do easly? Please help me... I use Telerik Rad AJAX 2009 Q3.
1 Answer, 1 is accepted
0
Accepted
Hello SoD,
Basically, there are two options to handle this, when databinding the grid to this dataset, and/or performing calculations on this data.
The first is to merge the data, for example by using a join statement. This would allow you to pass the data and directly allow the control to make calculations with it.
The other would be to make custom queries to the related data, when binding the grid, or when supplying cumulative data - such as footer totals.
I hope one of these options is suitable for you.
Sincerely yours,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Basically, there are two options to handle this, when databinding the grid to this dataset, and/or performing calculations on this data.
The first is to merge the data, for example by using a join statement. This would allow you to pass the data and directly allow the control to make calculations with it.
The other would be to make custom queries to the related data, when binding the grid, or when supplying cumulative data - such as footer totals.
I hope one of these options is suitable for you.
Sincerely yours,
Yavor
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.