Page 1 of 2

sum of the amounts of the previous page

Posted: Mon Jan 09, 2023 1:19 pm
by Nuria
Hi!
I have several reports that are not doing the sum of the amounts of the previous page correctly.

As you can see in the excel on the second page, the sum of the previous amounts is correctly, but from the third page it is adding an extra line.

-- Excel

First page Second page Total
Total 1960,15 4.253,76 6.213,91

For the sum I use this code

Code: Select all

{cSumRunning(Data,AUX_INVENTARIO.IMP_PV_E)-cSum(Data,AUX_INVENTARIO.IMP_PV_E)}

The version of Stimulsoft Reports.Net2021.4.4

Re: sum of the amounts of the previous page

Posted: Mon Jan 09, 2023 2:15 pm
by Max Shamanov
Hello,

Please send us a test data that reproduce the issue for your report.

Thank you.

Re: sum of the amounts of the previous page

Posted: Tue Jan 10, 2023 7:57 am
by Nuria
Hi!

I have tried to reproduce the error with a csv or xml file but it does not happen.

We connect to an Oracle database to obtain the data and the report seems to have a problem with pagination since it adds an extra line in the calculation of the totals at the page level.

I don't know how I can give you some example of data since our database is huge and I can't reproduce it with a file.

Can you give me any clue as to what might be going on?

Re: sum of the amounts of the previous page

Posted: Tue Jan 10, 2023 3:10 pm
by Max Shamanov
Hello,

Please create a simple script to create tables and inserting test data, and send us for analysis.

Thank you.

Re: sum of the amounts of the previous page

Posted: Tue Jan 10, 2023 3:54 pm
by Nuria
Hi!!

I am attaching the table and the table data for the report to work.

Re: sum of the amounts of the previous page

Posted: Wed Jan 11, 2023 6:20 am
by Max Shamanov
Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
#9822

Re: sum of the amounts of the previous page

Posted: Tue Jan 17, 2023 4:48 pm
by Nuria
Hi Max!

is there any update on this issue?

Thank you.

Re: sum of the amounts of the previous page

Posted: Tue Jan 17, 2023 9:46 pm
by Lech Kulikowski
Hello,

We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.

Thank you.

Re: sum of the amounts of the previous page

Posted: Fri Jan 27, 2023 1:15 pm
by Max Shamanov
Hello,

Please check the attached report with some changes.
For the databand we changed the property Can Breake = fasle and for all text components on it we changed the property Grow to Height = true.

Thank you.

Re: sum of the amounts of the previous page

Posted: Thu Feb 02, 2023 8:28 am
by Nuria
Hi!

Thanks the solution works.