Report sum variable

[Nuria]

Hi ,
I have a report that does not calculate well.

The variable TOTAL_IMPORTE represents the sum of ah_facturas.importe which is placed inside a databand.





The variable is in two places of the report but the calculations show them wrong when there is only one line left on the next page.







The last row should not be added. What I do wrong?
Thanks in advance.

[HighAley]

Hello.

We can't reproduce the issue without your data.
We can only guess that the issue is because of the rendering process of the report.
Try to use the After Print method of the Data Band to calculate the sum.
If you still need our help, please, send sample data for your report.

Thank you.

[Nuria]

Hi !

I have send a sample report with test data.

Thanks & Regards

[HighAley]

Hello.

We have found a solution for you.
You could use the Totals.cSumRunning() and Totals.cSum() functions.
You event don't need to use the variable.
Please, look at the attached report template.

Thank you.

[Nuria]

Hi !

It works !!

Thanks and regards.

[Lech Kulikowski]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.