Symptom
- A report is created against several tables in a proprietary database through an ODBC connection using Crystal Reports 6.0 Report Designer.
- The report previews and functions as expected.
- Upgrading Crystal Reports 7.0 causes the characters "00" to be appended to the alias for each table in the report.
View the SQL query in the Crystal Reports 6 Designer under Database > Show SQL Query. The following query is generated for a simple report containing a single field in the detail section:
SELECT TableName."FieldName"
FROM "TableName" TableName
View the SQL query in the Crystal Reports 7 Designer under Database > Show SQL Query. For the same report, revealed the following query was generated:
SELECT TableName00."FieldName"
FROM "TableName" TableName00
Read more...
Product
Keywords
APPEND TABLE ALIAS SQL QUERY PROPRIETARY ODBC Seagate Crystal Reports Connectivity_ODBC Custom/Proprietary Incorrect Join/SQL Syntax , c2005112 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed
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.