In Crystal Reports 9, a report displays incorrect or incomplete data when using a native connection to a Pervasive version 8 database. The report contains two tables that are linked by an equal inner join on ZString type fields. An ODBC connection to the same database returns the correct data.
This is a known issue with Crystal Reports 9 and has been tracked. The Track ID is ADAPT00377829.
As of the publish date of this article, there is no file update to correct this issue.
To work around this issue, convert to an ODBC connection.
For more information, please refer to Note 1216574.
PERVASIVE NATIVE CONNECTION CRYSTAL REPORT 9 ZSTRING LINKING WRONG DATA Crystal Reports Incorrect data returned Pervasive 8 database Native connection issue , c2016752 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed