I have had a problem with creating SQL expression fields in CR.
I have always catched the error "Syntax error found in the statement" when trying to edit any SQL statement in the SQL Expression Editor(Crystal Reports), even it was a very simple one and copied/parsed from the Crystal SQL Designer which had executed it well, for example:
I wonder if the error actually resulted from the syntax or other reasons ?
I am expecting the answer from all of you who is interested in.
Thanks in advance !