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 for Me (Login required).

Search for additional results

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