Hierarchy Grid : Footer Total

[Kannan]

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

[Shinu]

Hello Kannan,

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

Thanks,
Shinu.

[Kannan]

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