Original issue moved from:
Consult the original issue for any attachments.
[ 1521064 ] BigDecimal Fields shows wrong data
Submitted By: petershen - pshen
Date Submitted: 2006-07-12 02:27
Last Updated By: teodord - Comment added
Date Last Updated: 2006-07-12 07:52
Number of Comments: 1
Number of Attachments: 0
Assigned To: Nobody/Anonymous
BigDecimal Fields shows wrong data
I have a problem here, in my report, I have some number data, and I use BigDecimal type. for some data, (not often), in the database, the number is 1.7 while the report shows me 1.6999999. I tried jasperreports0.5.3 and also the lastest one: version 1.2.4, the problem is the same.
anyone has the same problem and any solution for that?
I defined the field in jasperreports like this:
and I do not use any pattern.
thank you for any help!
Date: 2006-07-12 07:52
Sender: teodordProject Admin
Logged In: YES
I don't think this is related to JasperReports and the problem is with the numbers themselves. You should probably try to put aside JasperReports for a moment and try execute the query yourself with JDBC and see what numbers you get from the database.
I hope this helps.
No Files Currently Attached