SAP Knowledge Base Article - Preview

1543038 - Incorrect result set returned in Crystal Reports when mixing Left Outer Joins and Inner Joins links

Symptom

  • Incorrect data set returned in Crystal Reports.
  • Left Outer Joins act likes an Inner Joins.
  • Left Outer Joins doesn’t return all the records from the table on the left.
  • In Crystal Reports, when performing a left outer joins from Table A to Table B, and an inner joins from Table B to Table C, the incorrect data set is returned if each table is from different database connection.


Read more...

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025

Keywords

inner join left outer join table incorrect result , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.