[#10766] - Incorrect subtotal

Posted by m.christianen on April 19, 2018 - 12:05am
Category:
Bug report
 Priority:
Normal
 Status:
New
Project:
JasperReports® Library
 Severity:
Major
 Resolution:
Open
Component: Reproducibility:
Always
 Assigned to:
Subscribe

Hi,

When creating a running subtotal of all entries in a group on the previous page the first row of the current page the value of the first row of the current page is taken into account leading to an incorrect subtotal. Please find attached an example of this behavior.

Kind regards,

Maarten

AttachmentSize
File repro_subtotals.xml59.55 KB
Binary Data repro_subtotals.jrxml4.93 KB
v6.2.0
group report
m.christianen's picture
m.christianen
2
Joined: Mar 7 2018 - 12:16pm
Last seen: 3 years 1 week ago

7 Comments:

#1Posted by yann22580 on April 19, 2018 - 12:32am

Hi,

$V{price_subtotal} in the "Company" group header is set with 'evaluation time' to 'now'.
To get a subtotal of this group the evaluation time should be set to '[Group] Company'.

Regards,

Yann

AttachmentSize
Image icon subtotal_group_company.png56.89 KB
#2Posted by m.christianen on April 19, 2018 - 2:20am

Hi,

When changing the evaluation time to the group I am getting an incorrect (not wanted) result. The aim is to get the total of the previous page within the group. So for example if group A starts on the previous page and there the values 1 and 2 are listed for that group I want on the first rule on the following page 3 (as a subtotal of the previous printed amounts).

After changing the evaluation time the subtotal seems to no longer take into account the page split (but showing the total for the complete group on top of every page).

Kind regards,

Maarten

AttachmentSize
Image icon example2.png10.65 KB
Image icon example_1.png18.94 KB
Image icon evaluation_time.png29.2 KB
#3Posted by yann22580 on April 19, 2018 - 5:46am

Humm, I'm not sure if you can do that with the native properties or how to do it..

I think the result expected as something to do with the 'increment type' set to 'page' of the variable 'price_subtotal'.
Not the textfield with te variable 'price_subtotal' but the variable itself in the window Outline/variables section.

I think you will get for the variable 'price_subtotal', for example :

p1 - 2
p2 - 5
p3 - 6
-- new group --
p4 - 4
...

but you expected :

p1 - 0
p2 - 2
p3 - 5
-- new group --
p4 - 0
p5 - 4

As far as I know there are no properties (on evaluation time, reset type, increment type) allowing to set to 'previous page' as you need.
Maybe subtracting 2 variables with properties setted diferently...

Regards,
Yann

#4Posted by yann22580 on April 19, 2018 - 5:48am

I think this explanation may help you :

https://community.jaspersoft.com/wiki/getting-previous-records-value-cal...

#5Posted by m.christianen on April 19, 2018 - 6:27am

Hi Yann,

Thanks for the reference. I will give it a try.

Kind regards,

Maarten

#6Posted by morlandin on April 19, 2018 - 6:28am

Hi, to me this seems more a JasperReports related question than a JSS one. JSS is used only to design the report, report execution and filling are completely done by the JasperReports library.

#7Posted by m.christianen on April 19, 2018 - 10:03pm

Hi,

I updated the ticket. It seems to be impossible to add more than one project.

Kind regards,

Maarten

Feedback
randomness