Your sums appear to be totaling fields which are already summary-calculation totals.
Sums in subSummary parts depend on both proper sorting, and on being actual Sums of numbers/amounts, not sums of calculated sums.
If you retotal your calculated sum fields, you will get amounts which are too large, possibly the sum of all records, possibly even more, depending on howand what the calculated field is summarizing. (We cannot see your relationship structure to know what's being sumarized in the calcs across the various relationships.)
Tks for your interested in help me.
I am sending 2 images of the report.
The First image of the report, OK no problem and don,t have problem.
The third image the total in the Footer, but the total is incorret, because the Sum is a Sum of total records of database.
This total field is a Summary field com Total of.
The Second a image of the Relationship.
The Field Total Pago and Total Recebido is a Sum by calcutation using by Relationship and I need use the relationship because a need of total paid and received by specific date, field date in header.
Now I need only to make a field to Sum each column in this Example, Sum of total pago = R$ 33.00 Sum of total recebido = R$ 542,49.... but this Sum not respect the relationship and Sum the total of records in database.
I need to create a field that sum only the value each column, no all records.
Tks for you help.
Try putting the final total as a sub-Summary field in a "Trailing Grand Total" layout part instead of the page footer. Use the same summary field you use in the sub-summary parts in the trailin grand total part.
Let's see if that makes a difference before trying to analyze the relationships and the calcs which summarize across them.