Page 1 of 1

Report sum variable

Posted: Wed Jul 18, 2018 7:20 am
by 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.

Image

Image

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.

Image

Image

Image

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

Re: Report sum variable

Posted: Fri Jul 20, 2018 9:58 pm
by 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.

Re: Report sum variable

Posted: Tue Jul 24, 2018 7:26 am
by Nuria
Hi !

I have send a sample report with test data.

Thanks & Regards

Re: Report sum variable

Posted: Thu Jul 26, 2018 10:28 pm
by 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.

Re: Report sum variable

Posted: Mon Sep 03, 2018 10:45 am
by Nuria
Hi !

It works !!

Thanks and regards.

Re: Report sum variable

Posted: Mon Sep 03, 2018 1:48 pm
by Lech Kulikowski
Hello

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

Thank you.