Variables not summing within dataset

[dnewsom]

I'm working on updating a bunch of our reports to use the new table elements. I've got my dataset setup and everything looks like it's correct. I have a group setup within it and I am trying to create a variable that will sum a price for that group. I've got it setup with calculation sum, reset on the group and no increments.

When I put that variable in the group footer band of the table and all it reports is the value of the last row instead of the sum of that group. I've tried setting the evaluation time to auto, band, group and now but the result seems to be the same.

Any advice would be appreciated.

[mickyrox]

Hi,

Are you sure you set your expression class to java.math.BigDecimal?

Not sure if that's the issue but, I faced the same problem when i used strings.

 

 

Hope this Helps,

michael

 

[dnewsom]

We're using a java.lang.Double but yes, it is set. It'll show the last field value, but it doesn't seem to want to sum.

[shainaztamboli]

 hi,

I have tried the same and for me its working...check ur steps-->

Create a new variable say PriceSum

Variable class type--> whatever u want(Integer/BigDecimal)

calculation type --> sum

Reset Type--> group

Reset group --> ur group name

Increment type--> none

variable expression --> your field name(price)

thats it.

and use this field.

 

hope this help you.

 

-Shainaz

[dnewsom]

Did you use the variable in a table or on the main report? Using it on the report works just fine, it only seems to be when I put it in a table that I have issues.