Skip to Content
avatar image
Former Member

Value on Crystal Reports does not match value from database

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded