Cannot sum the right value from subreport

[Super Bread]

Hello,

This report calls the SubReport2 and want to return the sum of fields from SubReport2 to MainPage but there are 2 problems for sum of two fields. Please read the attached file and the following for the details.

1. It shows the Text11 "payment1.sumpaidamt1" in DataBand3 of Page_SubReport2. I want to show the sum of this field.
The Text31 "{Sum(payment1.newcontractid==loaninfo.contractid?payment1.sumpaidamt1:0)}" is shown in the GroupFooterBand1 of Page1.
The problem is: there are 3 records in SubReport2, it shows sum of these 3 records, but it only sum the 3rd records.

2. The Text22 "{sumSettle=SumIf(DataBand1,payment1.sumpaidamt1,payment1.newcontractid==loaninfo.contractid)}",
I assign toe variable "sumSettle". Then, the Text32 "{Sum(DataBand1,sumSettle)}" should be shown the sum of Text22.
The problem is: there are 3 records, it should be sumed of field Text32 but it sum 3 times of the 3rd records.

Thanks,
Super Bread

[Super Bread]

The report file is attached for your reference, thanks.

[HighAley]

Hello.

You didn't set the Data Source for processing.
Please, try to use Sum(DataBand3, payment1.newcontractid==loaninfo.contractid?payment1.sumpaidamt1:0)

Thank you.

[Super Bread]

Hello,

I try to set Sum(DataBand3, payment1.newcontractid==loaninfo.contractid?payment1.sumpaidamt1:0) in Text31. But the result is the same as before. Please help.

Thanks.

[HighAley]

Hello.

Please, send us a sample data for your report for analysis.

Thank you.

[Super Bread]

The sample data is attached for your analysis, thanks.

[HighAley]

Hello.

We need time to prepare an answer for you.

Thank you.

[Super Bread]

Hello,

May I ask any update?

Thanks.

[HighAley]

Hello.

We are still working on our problem.
We will let you know about the results.

Thank you.

[Super Bread]

Hello,

I'm looking forward to your reply. Many thanks.