take sum of similar column from multiple data table based on unique id in crystal report

See more:

CrystalReports

I have four datatables like

Table 1

id        name           Afee        Insfee
1         a              100        10
2         b              100        10

Table 2

id        name           Bfee        Insfee
2         b              100        10
1         a              100        10
3         c              100        10

Table 3

id        name           Cfee        Insfee
1         a              100        10
3         c              100        10

Table 4

id        name           Dfee        Insfee
1         a              100         10
2         b              100         10

in the crystal report i want to get the result as

Name       Afee      Bfee      Cfee     Dfee     Insfee    total
a          100       100       100      100      40         440
b          100       100       0        100      30         330
c          0         100       100      0        20         220

where this INSfee should be the sum from all the four table for a particular ID and total should be the sum of a row in that in that report.

How to do this in a sap crystal report.