Symptom
- Report connecting to a Btrieve database finishes in time X
- The same report running in a Visual Studio .NET application will take four to 5 times longer to finish
Environment
- SAP Crystal Reports 2008
- Microsoft Visual Studio 2008
- SAP Crystal Reports, developer version for Microsoft Visual Studio
- Microsoft Visual Studio 2010
Reproducing the Issue
- Create a report connecting to a Btrieve database
- Run the report in the Crystal Reports Designer - note the performance
- Run the same report in a Visual Studio .NET application - note that performance is much worse
Cause
- The issue has been escalated for a fix
- Reference ADAPT01681032
Resolution
The issue is resolved in Service Pack 6 for SAP Crystal Reports, developer version for Microsoft Visual Studio
See Also
- Additional suggestions to improve performance:
- Find the clientSDKOptions.xml file in C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86. Change “VerifyDatabaseOnSetDataSource” from “True” to “False”.
- Add the Btrieve Key under HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Database, then we add the string value “DoNotPadWithBlanksToFillCharColumns” and set it to “Yes”.
- Add the String Value "AllAtOnce_BackwardCompatible" under HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Database\QueryEngine and set the value to 1.
- Refer to KBA 2003458 - Crystal Reports .NET Runtime application slow to load with no internet access .
Keywords
crvs cr4vs 2012 slow speed net , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Bug Filed
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio