MikeCitizens
Technical User
I wonder if anyone else has this same issue.
I have two users, who work with crystal reports regularly running pre-built reports. However whenever a True/False statement is used they receive an error. We have about 20 users working with crystal reports and only these two users have this issue.
The most common statement is basically IsDeleted=False
The error they are receiving is
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server}Invalid column name 'FALSE'
I have even tried using an if then else statement to get around it. But the same error was received.
Has this happened to anyone else?? They were running crystal 7 but that was removed and upgraded to 8.5 when this problem appeared. However the error message is still received in 8.5
Let me know if anyone knows how to fix this
Appreciate any help
Mike
I have two users, who work with crystal reports regularly running pre-built reports. However whenever a True/False statement is used they receive an error. We have about 20 users working with crystal reports and only these two users have this issue.
The most common statement is basically IsDeleted=False
The error they are receiving is
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server}Invalid column name 'FALSE'
I have even tried using an if then else statement to get around it. But the same error was received.
Has this happened to anyone else?? They were running crystal 7 but that was removed and upgraded to 8.5 when this problem appeared. However the error message is still received in 8.5
Let me know if anyone knows how to fix this
Appreciate any help
Mike