I have converted a report from Crystal Reports 8 to Crystal Reports .NET that comes with visual studio .net by adding the report to an existing project and saving it in the new format. I did a comparison between the old and new reports by running a query with both of them using the same database and search parameters. When I noticed that the total fields were slightly off I narrowed down the searches and discovered that a few transactions (this report deals with transactions) were missing from the new report. Upon looking at the SQL queries that power each of the reports I noticed that the old one started with
{ oj (
just after the FROM statement. The new report eliminated this completely. I'm not very familiar with Crystal syntax, but is this some OUTER JOIN statment that was eliminated in the new version of Crystal? When examining the missing transactions I couldn't find any condition where there was an inner join that wasn't satisfied.
Any clue as to what might be going on?
{ oj (
just after the FROM statement. The new report eliminated this completely. I'm not very familiar with Crystal syntax, but is this some OUTER JOIN statment that was eliminated in the new version of Crystal? When examining the missing transactions I couldn't find any condition where there was an inner join that wasn't satisfied.
Any clue as to what might be going on?