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.
SAP Knowledge Base Article - Preview