SAP Knowledge Base Article - Preview

2862367 - How to remove the database table owner name of the SQL Query sent by Crystal Reports for Enterprise?

Symptom

  • How to remove the table qualifier?
  • How to remove the table owner name?
  • How to remove in the SQL Query, the schema that precede the table name, in Crystal Reports for Enterprise?
  • How to remove the database name, and schema name, that appears for each table in the FROM clause of the SQL Query?
  • When viewing the SQL Query generated by Crystal Reports for Enterprise, the name of the database, and database owner appears in the SQL statement.
    How can you remove the name of the database owner from the SQL statement?


Read more...

Environment

  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

CR4E, CRFE, CR for Enterprise , KBA , BI-RA-CRE , Crystal Reports for Enterprise , BI-BIP-IDT , Information design tool , 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.