cancel
Showing results for 
Search instead for 
Did you mean: 

Value on Crystal Reports does not match value from database

Former Member
0 Kudos

I created a stored procedure onto MSSQL server. I execute that proc in crystal reports. I have a column that is set up to produce a bit (1,0) for true or false. After I created and previewed my crystal report the data does not match what is on the database. I get values of 4,037 or 80 or 5 in place of the bit and no 1 or zero. Why would the column produce a different value on crystal then the output of my stored procedure? Note: I have done this in the past but never experienced this issue.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Randall,

How do you connect to the database? ODBC or OLEDB and which driver do you use?

-Abhilash

Former Member
0 Kudos

OLEDB

Answers (0)