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

Symptom

  • 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.


Read more...

Environment

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

Product

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

Keywords

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.