2004 IR Help Posted August 24, 2006 Share Posted August 24, 2006 By: Rodrigo - digobr Value error - sum 2005-11-11 06:07 hi everyone, i'm new to jasper reports (and so to the forum), and i'm having a big problem. i have a report where i show some values (in the currency pattern). and then i have to show the total (sum) of this values (all the column), but the result given by the report isn't right. i'm using iReport 0.5.2 and JasperReports 1.1.0. u can see this "errors" in the following links: pic 1 http://us.f1.yahoofs.com/bc/487a2b9e/bc/Shared/exemplo01.jpg?bfgNKdDBvqU5piMT pic 2 http://us.f1.yahoofs.com/bc/487a2b9e/bc/Shared/exemplo02.jpg?bfgNKdDBNV.BYpJ_ in picture 1, the result's wrong, i was supposed to be "R$ 126.172,52", not "R$ 126.172,54". in pic 2, the sum (without pattern) is "wrong" (decimal part). By: jorge - sirion_oef RE: Value error - sum 2005-11-11 15:39 what formula are you using for calculate the sum? how do you use the variable that contains that formula? is your report is not too big post it, for help you easier Link to comment Share on other sites More sharing options...
honeyani Posted September 16, 2008 Share Posted September 16, 2008 Can anyone suggest me how to set SUM formula to jasper generated excel , with cell type double..With cell type Integer - Apache's POI- HSSF API helps to set formula..it doesn't works with double cell type! any suggestions? Link to comment Share on other sites More sharing options...
honeyani Posted September 16, 2008 Share Posted September 16, 2008 Can anyone suggest me how to set SUM formula to jasper generated excel , with cell type double..With cell type Integer - Apache's POI- HSSF API helps to set formula..it doesn't works with double cell type! any suggestions? 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