SQL bit field = 0/1 on one machine and true/false on another?

[jlbsloan]

Both computers have SQL 2000, Windows 2000, Crystal Reports 8 Pro. When I try to run the report on both computers, one works fine with the 0/1 comparison and the other errors out and wants a true/false value. Does anyone know if there is a setting in Crystal or a patch that will fix this problem?

 

[kenhamady]

v8 has a hot fix that fixes some problems like this, but unless you have already patched the one that works it probably isn't the problem.

Are you using ODBC? you might have two different ODBC drivers or two different versions of the SQL client. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[IdoMillet]

Try to compare the following setting on both PC's:

Go to:
File
Options
Fields (Tab)
Boolean (button)
Boolean (Tab)

Possibly, the "Boolean Text" option is set to
"True or False" on one PC and
1 or 0 on the other.

hth,
- Ido
CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm

 

[kenhamady]

Ido,

But that should only affect formatting, and shouldn't generate errors. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[jlbsloan]

The hot fix did the trick. One of the computers was on version 8.0.0.371 and it also had a version 6.? p2sodbc.dll.

Thanks

 

[IdoMillet]

I Should have read the message body and not just the title... )

- Ido CUT (Crystal UTilities): e-mailing, exporting, electronic bursting & distribution of Crystal Reports:

http://sobpc02.bd.psu.edu/CUT/CUT.htm