How to show a row sum amount by group CG Group in Report.

caroline_85

Hello experts!

I am making a report based on available report. The new report only show a row sum according to group CG Group instead if show all as old report.
Exam: Available report
CG Code Amount Current 1-30days 31-60days 61-180days >180days
1.1 50 10 100 50 10 5
1.1 30 20 60 35 20 20
1.1 20 30 80 7 80 60
1.2 30 50 50 1 100 80
1.2 40 70 90 5 75 15
2.3 100 20 20 150 20 30
3.1 60 10 10 80 10 4
3.1 30 60 5 100 5 60

New report as sample:
CG Code Amount Current 1-30days 31-60days 61-180days >180days
1.1Total 100 60 240 92 110 85
1.2Total 70 120 140 6 175 95
2.3Total 100 20 20 150 0 30
3.1Total 90 70 15 180 15 64
I see code of available report has SQL sentence as
select AmountMST from CustTransOpen where
custTransOpen.AccountNum == CustTable.AccountNum
&& custTransOpen.TransDate <= balanceAs
&& CustTransOpen.TransDate >= compareDate1
&& CustTransOpen.TransDate <= compareDate2
I have created view get data from 2table (Custtransopen, Custtable), then I also write SQL to group CG Group as
select sum(AmountMST),StatisticsGroup from SKV_CustAging3
group by StatisticsGroup
where SKV_CustAging3.TransDate <= balanceAs
&& SKV_CustAging3.TransDate < compareDate1;
I aslo try to use Section Group to total every CG Group but I still show detail record, finally I show sum total for every CG Code. Are there any way to show only one record sum total for every CG?
Please help me. I am new officers to make this report, so I don't many experience about Axapta.Thanks.