IsNull fields in crystal 8 with SQL 7.0

[valle123]

We recently moved to Crystal Reports version 8 from version 7.

The reports that look for isnull in string fields no longer
work.

When we run the report in crystal 7 we get 4 records,
when we run the report in crystal 8 we get 384 records.

Our database is in Sql 7.

 

[kenhamady]

Same ODBC driver and connection?
Same instance of the database?
Same Report?

If everything else seems the same, I would remove that criteria and examine the records themselves to see what values are stored for these fields.

For more help it would help if you could post the formula that uses IsNull() and explain where it is used. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[MalcolmW]

IsNull() is a function that has been around for at least four major versions, and has not changed. It is not the same as the SQL Server function IsNull(x, y) though, which does not (by definition) always return a boolean. Malcolm