generated values in pdf and html format are correct but when exported to excel some have discrepancies

0

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?

boyet06's picture
Joined: Feb 28 2013 - 2:27am
Last seen: 6 years 2 weeks ago

2 Answers:

0

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

http://www.thomaszimmer.net

Thomas Zimmer's picture
Joined: Oct 2 2012 - 1:35am
Last seen: 1 week 1 day ago
0

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?

boyet06's picture
Joined: Feb 28 2013 - 2:27am
Last seen: 6 years 2 weeks ago

Is the datataype correct of the field? Java.lang.double or init?

sjoerd.jump - 6 years 4 months ago

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)

boyet06 - 6 years 4 months ago

pls. post your report

Thomas Zimmer - 6 years 4 months ago
show 1 more...

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.

boyet06 - 6 years 4 months ago
Feedback
randomness