BigDecimal Fields shows wrong data

Original issue moved from:

https://sourceforge.net/tracker/index.php?func=detail&aid=1521064&group_id=36382&atid=416703

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

Priority: 5

Summary:

BigDecimal Fields shows wrong data

Hi,

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:

$F{fieldname}==null?new BigDecimal(0):$F{fieldname}

and I do not use any pattern.

thank you for any help!

Peter

Comments

Date: 2006-07-12 07:52

Sender: teodordProject Admin

Logged In: YES

user_id=332465

Hi,

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.

Teodor

No Files Currently Attached