SAP Knowledge Base Article - Preview

1210970 - Upgrading to Crystal Reports 7 appends "00" to the table alias in SQL Query

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

SAP Crystal Reports all versions

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.