SAP Knowledge Base Article - Preview

2183512 - Tables and joins are missing from generated SQL Query in SAP Crystal Reports 2011/2013 after promoting Business Views content


  • Incorrect SQL generated in Crystal Reports Designer after promoting  Business Views from a Test/Development (source) system to your Production (target) system.
  • If you compare your source and target SQL Query in Crystal Reports Designer using the Database -> Show SQL query menu, you may recognize that tables, joins are missing from the query on the target system.



  • SAP Crystal Reports 2011/2013
  • SAP Business Intelligence Platform 4.x


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013


BWM, promote, SQL , incorrect, CR 2011,CR2013, CR 2013, CR 2011, wrong, business view, security, promotion , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

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.