Symptom
- Error: Unknown column 'name.name' in field list.
-
Not able to query tables with special characters in table name.
- When refreshing a report in Crystal Reports, that contains a table with special characters, it fails with the error:
"Unknown column 'name.name' in field list"
Read more...
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
-
SAP Crystal Reports 2013
-
SAP Crystal Reports 2016
- MySQL
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016
Keywords
dash, hyphen, underscore, table name , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview