-
February 9th, 2010, 02:36 PM
#1
Problem with decimals
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?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|