When trying to use the Intelligence reporting I get the following error;
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]'' is an invalid date value. If using '0000-00-00', replace it with NULL for a constant, or IS NULL in expressions.
I have tried to change this to many things and different kinds of reports but with no success. Any ideas?
You could try using COALESCE