SQL Expression Problem in Crystal 11.5

[MissAnn]

Problem with SQL Expressions not working in Crystal 11.5
My Sql expressions used to work fine the only change that I can think of is that I did the Overridden table in the datasource and changed that to the table name so that the full db name isn't a part of the query. Ever since I did that, my sql expressions have been getting a strange error:

Database Connector Error "illegal zero-length identifier"

Can anyone help? I've heard that sql expressions are not allowed in a command. But I have tables so I'm not sure why I keep getting this error.

 

[MissAnn]

Update:

I saved a copy of the report with the Datasource>Table>Properties>Overridden Qualified Table Name:
set back to nothing instead of the actual table name and my sql expressions work again! Is this a bug in Crystal Reports? Shouldn't you be able to Override the qualified table name of the report and have sql expressions working at the same time?