Hello,
Recently we got a new version of our Finance application ( Navision Software ). Consequence is that many of my Crystal Reports made with the former version, are worthless.
Problems are:
(1) When I try to refresh the reports I got the following statement:
ODBC error: "[Navision Software a/s][Navision Attain ODBC Driver]Invalid operand operator:>="
following by the statement:
"Error detected by database DLL".
I think the problem is caused by the "Date". Because when I remove the "Date" out of the "Select Expert" the report do run. But then I got all data and that's not the meaning of the "Select Expert". If there is no "date"-field in my report I've got no problems at all.
(2) Also when there is NO date mentioned in our Navision-database for a specific field, you also expect an empty field in Crystal Report. However I got 01-01-1753 in Crystal reports.
Is there someone who can help me ? Or maby there's someone who has the same troubles ?
Sleepless.
Recently we got a new version of our Finance application ( Navision Software ). Consequence is that many of my Crystal Reports made with the former version, are worthless.
Problems are:
(1) When I try to refresh the reports I got the following statement:
ODBC error: "[Navision Software a/s][Navision Attain ODBC Driver]Invalid operand operator:>="
following by the statement:
"Error detected by database DLL".
I think the problem is caused by the "Date". Because when I remove the "Date" out of the "Select Expert" the report do run. But then I got all data and that's not the meaning of the "Select Expert". If there is no "date"-field in my report I've got no problems at all.
(2) Also when there is NO date mentioned in our Navision-database for a specific field, you also expect an empty field in Crystal Report. However I got 01-01-1753 in Crystal reports.
Is there someone who can help me ? Or maby there's someone who has the same troubles ?
Sleepless.