dnewsom Posted July 27, 2010 Share Posted July 27, 2010 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. Link to comment Share on other sites More sharing options...
mickyrox Posted July 28, 2010 Share Posted July 28, 2010 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 Link to comment Share on other sites More sharing options...
dnewsom Posted July 28, 2010 Author Share Posted July 28, 2010 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. Link to comment Share on other sites More sharing options...
shainaztamboli Posted July 29, 2010 Share Posted July 29, 2010 hi,I have tried the same and for me its working...check ur steps-->Create a new variable say PriceSumVariable class type--> whatever u want(Integer/BigDecimal)calculation type --> sumReset Type--> groupReset group --> ur group nameIncrement type--> nonevariable expression --> your field name(price)thats it.and use this field. hope this help you. -Shainaz Link to comment Share on other sites More sharing options...
dnewsom Posted July 29, 2010 Author Share Posted July 29, 2010 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now