SAP Knowledge Base Article - Preview

3018673 - SELECT DISTINCT not added to the SQL Query for reports based on a Universe in Crystal Reports for Enterprise

Symptom

  • Report returns more data than expected.
  • SQL Query generated for the report does not use SELECT DISTINCT
  • Report based on a Universe in Crystal Reports for Enterprise, generates a SQL Query with a SELECT statement only, when the expecatation is to have a SELECT DISTINCT statement. 


Read more...

Environment

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

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CRFE, CR for Enterprise, CR4E, CR for Ent , KBA , BI-BIP-SL , Semantic Layer , BI-RA-CRE , Crystal Reports for Enterprise , 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.