Hierarchy Grid : Footer Total
Top achievements
Rank 1
Kannan asked on 06 Sep 2011, 01:42 PM

Hi,

I am using Radgrid with Hierarchy concept. The Main Table has a Total amount and the detail table also have another total amount. In the Footer i need to get the sum of both tables. For eg: i have given the grid sample below

SNo      Item Name        Unit        Qty      Price       Total
1.          Item1                Nos        10       100          1000             ----> Main Table
SNo        Item Name     Unit         Qty         Total
1.           ItemDetail1      Nos        10          500              --->Detail Table
2.           ItemDetail2      Nos         5           250
2.        Item2               Nos            20        100        2000

Total :     3750             ----> Footer Total

Please guide me in this regards

Thanks
Kannan. S

## 2 Answers, 1 is accepted

0
Shinu
Top achievements
Rank 1
answered on 06 Sep 2011, 01:50 PM
Hello Kannan,

Check the following Code-Library which explains the similar scenario.
Calculated column with total in footer.

Thanks,
Shinu.
0
Kannan
Top achievements
Rank 1
answered on 09 Sep 2011, 06:39 AM
Hi Shinu,

The given link is not the same scenario. Because in that they used to calculate the grid totals and show in two different footers. One is the Main table footer and other is the detail table footer. In my case i need only the Main table footer. And in that footer both Main Table and detail tables values should be calculated and displayed.

The Example in the give link is

SNo      Item Name        Unit        Qty      Price       Total
1.          Item1                Nos        10       100          1000
SNo        Item Name     Unit         Qty         Total
1.           ItemDetail1      Nos        10          500
2.           ItemDetail2      Nos         5           250
Total :    750        ---- Detail Table Footer
2.        Item2               Nos            20        100        2000

Total :     3000             ----> Main Footer Total

But See my example which i have posted. I need the total value as 3750 and not two footers.

Thanks and Regards
Kannan.S

Tags
Grid