Skip to Content

Value on Crystal Reports does not match value from database

Aug 18, 2017 at 06:11 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Abhilash Kumar
Aug 21, 2017 at 07:50 AM

Hi Randall,

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


Show 1 Share
10 |10000 characters needed characters left characters exceeded