The issue occurs only when outer joins are used in a report once SP3 or any CHF (created after SP3) has been applied to Crystal Reports.
The problem is caused by the crqe.dll file version found in the COMMON FILES location.
The issue has been identified and tracked under ID ADAPT00735187.
A hot fix is available so that Crystal Reports XI now generates the correct SQL statement when a Left Outer join is used. Hot Fixes or Service Packs address this issue as indicated below. With the update(s), this issue is resolved.
Unless indicated otherwise, Critical Hot Fix updates from the FTP site have only been tested with English versions of our products.
Hot Fixes and Service Packs are not designed for OEM versions. Do not apply these updates if you are using an OEM version. To determine if you are using an OEM version, refer to the OEM Product Warning.
Crystal Reports XI
For Crystal Reports XI, the latest update for this issue is available on the Downloads area of our web site.
Monthly Hot Fixes and Service Packs
To determine if this issue is also addressed in a Monthly Hot Fix or Service Pack for your product, search the readme file for the Track ID number (that is, ADAPT00735187) in the latest Monthly Hot Fix or Service Pack. Monthly Hot Fixes readmes for Crystal products are found in the Downloads area of our web site.
Issues addressed on one operating system platform at the Weekly Hot Fix level may be addressed later on multiple operating system platforms (if applicable) at the Monthly Hot Fix and Service Packs level. For example, an issue only resolved on the Windows platform in a Weekly Hot Fix may be resolved later on UNIX platforms such as IBM AIX and Sun Solaris in future Monthly Hot Fixes or Service Packs for these platforms.
To determine if these issues are resolved in a Monthly Hot Fix or Service Pack on another platform, search for the Track ID number in the readme at the locations indicated above.
XI SP3 SP service pack 3 CHF Critical Hot Fix roll back FIRE 1211 , 9072590 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed