VB6 + SP3+ ODBC = Decimal Problem

[mcardia]

I have a problem with decimals in Crystal Report 8.0.1. We are migrating to .Net, but,
meanwhile, I need to solve some problems with my old programs.

The problem is that when I call the report from vb6 the report does not show decimals.
16.73 looks like 16.00.

In preview from Crystal Reports works perfectly. That problem happens only when I call the rpt
file from vb6.

I´m from Brazil, and my regional settings are set to our country. Here, the decimal separator is
"," (comma) and Thousand separator "." (dot).

If I change regional settings to English (USA) it works. But I can´t and I should not do this to 200 hundred computers spread through our 24 states.

I´ve tried to change the decimal character by using
...SetLocaleInfo Lib "kernel32" Alias "SetLocaleInfoA"...

and it changes the symbol, but the report still don´t works.

Does anyone have any clue?

Thanks

[VeenaMG]

Hi,

Right Click the Decimal Field and "Change Format"..
Check the option :'Use Windows Default Format" and check..
also check
Decimal (for "." Dec seperator, it should be "1.00") and Rounding (should be "0.01"")

Regards,
Veena

[mcardia]

I tried (again) but didn´t work.

It´s not about format. Searching in google I found similar problems. All of them
uses ODBC, just like me.

So I´m pretty sure that is related to ODBC. I tried to reinstall MDAC with the
lastest version, but XP SP3 don´t let me do it.

To confirm that is about database, I changed a column to use a formula instead.
In the formula I put

{MY_FIELD} * 100

So, 12.34 should be shown as 1234, but it´s shown as 1200.

Thanks.

[mcardia]

Hi again....

I changed the subject because is not related to Crystal Report anymore.

I ran some tests and now I know it´s a problem with SP3.

All machines with SP3 has this problem. The ones with SP2 do not.

Also it doesn´t happens just with Access MDB. With Oracle is the same.

Maybe something with MDAC 2.81 that SP3 installs and don´t let me to reinstall.

Any ideas?