Symptom
- When using a SQL Expression Field, and adding an Overridden Qualified Table Name in Crystal Reports, you receive the error:
'Illegal zero-length identifier'
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
Reproducing the Issue
- In Crystal Reports, create a report off Oracle.
- Create a SQL Expression Fields.
- Under the menu "Database", select "Set Data Source location", and under the table "Properties", add a table name for the option: "Overridden Qualified Table Name"
Cause
- No schema added to the table name of the SQL Expression Field, and therefore this is why it fails.
Resolution
- In the SQL Expression Fields, add the schema name.
Keywords
Oracle , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016