[#10766] - Incorrect subtotal

Category:
Bug report
Priority:
Normal
Status:
New
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

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
Joined: Mar 7 2018 - 12:16pm
Last seen: 2 years 1 month ago

7 Comments:

#1

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
#2

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
#3

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

#4
#5

Hi Yann,

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

Kind regards,

Maarten

#6

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.

#7

Hi,

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

Kind regards,

Maarten

Feedback