When i generated the report in jasper 4.7 (created using iReport 4.7.2), the report in the html is correct and also when you export to PDF but when i start to export to excel, some fields are not the same as the one generated in pdf/html. Is there any solution on this problem?
2 Answers:
Posted on May 22, 2013 at 12:20am
what do you mean exactly? is the field content cut?
try to use the option "Print When Detail overflows" for your text fields.
Cheers, Thomas
Posted on May 22, 2013 at 12:32am
No it's not truncated if that's what you mean. The problem is like for example I expect to have $30.40 in one field, when I generate the repor, the display shows correct and if I export to PDF it's the same value but when I export to excel the value becomes -12.30. Have u encountered this whenyou export to excel?
Is the datataype correct of the field? Java.lang.double or init?
yup the field is correct, it uses bigdecimal. It takes the value from the query then store it in a variable that sums all the values per given group then in divide the sum by a given divisor and round it to halfup. the generated values in pdf is correct and in the screen display but when exported to excel it changes values (even though i dont have any source code for the exporting to excel, just using the export facility of jasper 4.7)
pls. post your report
Can't post because the bank doesn't allow to take source codes from the work station. That's why it's hard to analyze.