sum of the amounts of the previous page

Stimulsoft Reports.NET discussion
Nuria
Posts: 9
Joined: Wed Sep 27, 2017 2:27 pm

sum of the amounts of the previous page

Post 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
Attachments
ALMA0500.mrt
(66.59 KiB) Downloaded 71 times
Inventario .xlsx
(167.58 KiB) Downloaded 71 times
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: sum of the amounts of the previous page

Post by Max Shamanov »

Hello,

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

Thank you.
Nuria
Posts: 9
Joined: Wed Sep 27, 2017 2:27 pm

Re: sum of the amounts of the previous page

Post 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?
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: sum of the amounts of the previous page

Post by Max Shamanov »

Hello,

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

Thank you.
Nuria
Posts: 9
Joined: Wed Sep 27, 2017 2:27 pm

Re: sum of the amounts of the previous page

Post by Nuria »

Hi!!

I am attaching the table and the table data for the report to work.
Attachments
Table.txt
(1.23 KiB) Downloaded 68 times
data.txt
(2.08 MiB) Downloaded 65 times
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: sum of the amounts of the previous page

Post by Max Shamanov »

Hello,

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

Thank you.
#9822
Nuria
Posts: 9
Joined: Wed Sep 27, 2017 2:27 pm

Re: sum of the amounts of the previous page

Post by Nuria »

Hi Max!

is there any update on this issue?

Thank you.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: sum of the amounts of the previous page

Post 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.
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: sum of the amounts of the previous page

Post 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.
Attachments
ALMA0500changed1.mrt
(68.63 KiB) Downloaded 60 times
Nuria
Posts: 9
Joined: Wed Sep 27, 2017 2:27 pm

Re: sum of the amounts of the previous page

Post by Nuria »

Hi!

Thanks the solution works.
Post Reply