Skip to Content
Former Member
Feb 09, 2010 at 01:22 PM

Problem with decimals


Hi! I´m not sure if this is the right forum...

I have a report that show prices, like $1.33

The problem is that it is not showing decimals correctly, it shows 1.33 like $1.00

I tried change the field format, but is not that.

In db (access/mdb) the value is right. It´s a float type.

My regional settings is not the problem either. I checked.

My locale is Brazil, so, my decimal separator is "," and the tousand separator is "." (In the exemple above, i used dot as decimal separator just to explain).

I´m calling the report with vb6. In Crystal Designer the price is correctly.

The problem occurs only when it´s called from my vb program, but the vb program just send a sql without mess with the values.

I´m using Crystal Reports, CRW32 and VB6 (SP6)

Any idea?