sum Variable shows value of last row in the report

[atsu]

I created a sum variable to calculate the total of of every column at the end of the page. The variable only shows the value of the final value in the result set. when I try to set the Expression class to java.lang.Double, the compiler throws the error:

Cannot cast String to Double. Attached is a code and a copy of the file..... Somebody  please help me out.......

[slow]

in the TOTAL_SQUID_QUANTITY variable definition you try to sum the squidQuantity field... but this field is defined (see the field declarations) as a String field...

so this is the reason of your casting error.

 

try to set squidQuantity type to double or float setting TOTAL_SQUID_QUANTITY type to the same one.

give us feedback.

_________________________________________

if it works... give me KARMA points please!    : ) 
_________________________________________

listening:  Underworld - Rez/Cowgirl

 

[atsu]

I have tried that but it still will not work.. it continues to show the value of the last row as the total

[slow]

in the variable definition you have set a reset type of "page"... are you sure to want it?

the other things seem to be correct... and the definition of a sum variable is a very simple task...

 

[rccsilva17]

I had the same problem. It worked when I changed the value of the field "Increment Type" to "None", in the Variable Proprieties.