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

Search for additional results

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