how to make summary fields across hierarchical groupings as Crystal Reports.

See more:

CrystalReports

, +

Hi all,
Vb.net 2005 with access and sql server depending on the client
I want to make summary fields across hierarchical groupings as Crystal Reports for A chart of account the data like this

1 Assets 0
11 AA 0
1101 AAA 0
1101001 AAAA 4000----2
1101002 AAAAA 5000----2
1102 ss 0
1102001 sss 2000
I want the child account added to parent one and the parent one summarize for its parent

So i need ex. is:
1 Assets 11000
11 AA 11000
1101 9000
1102 2000

i have the child accounts have type of 2 so its easily to suprress from the reports,
and when i use "summary fields across hierarchical" in the crystal report i found that all the parent get result , i tried to supress whoms the summary after summarize =0 but i couldn't ,,,

so i want to make it in gridview
So any solution here ????