Hi!

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 checked the field format, round rules, etc. Is not that.
I checked regional settings. Is not that either.
I checked dll (crystal) versions.

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

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

I´m calling the report with vb6 (sp6). In Crystal Report (designer, 8.0.1.0) the price is correctly.
It just happens when the report is called from vb program, and not in all computers. Just a few.

Same EXE, same RPT and same DLL, but the problem occurs.

Code in vb6:
sql = "SELECT ... PRE_PEDIDO_ITEM.PPIT_VLR_UNIT, PRE_PEDIDO_ITEM.PPIT_VLR_LIQ, ... " & _
"FROM ... PRE_PEDIDO_ITEM, ... " & _
"WHERE ... "
Rpt.LogOnServer "p2sodbc.dll", "DRP2", "DRP2", "XXXXX", "XXXXX"
Rpt.WindowShowRefreshBtn = True
Rpt.WindowShowSearchBtn = 1
Rpt.WindowShowCloseBtn = 1
Rpt.WindowTitle = "Order"
Rpt.WindowState = crptMaximized
Rpt.SQLQuery = sql
Rpt.Action = 1

Any idea?