This is a migrated thread and some comments may be shown as answers.
Hierarchy Grid : Footer Total
2 Answers 21 Views
This is a migrated thread and some comments may be shown as answers.
Kannan
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

Sort by
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
Asked by
Kannan
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 1
Kannan
Top achievements
Rank 1
Share this question
or