SAP Knowledge Base Article - Preview

2631163 - Not able to query tables with special characters in table name, in Crystal Reports

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.