SAP Knowledge Base Article - Preview

1875946 - SQL Query different after migrating reports based off an Oracle data source to a newer version of Crystal Reports

Symptom

  • SQL Query is different.
  • SQL Query syntax changes after the report is migrated from an older version of Crystal Reports to a newer version, and this causing performance issues.
  • Before, reports based off an Oracle data source added the tables linking in the WHERE clause, but in a newer version of Crystal Reports, the table linking is performed in the FROM clause. How to change the way the SQL Query is generated?


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • Oracle 11g
  • Oracle 12c

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

SQL Syntax, sql changes migrated crystal report, migrated crystal reports performance issue, performance issues crystal reports, CR 2008 SP5, crystal reports , 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.