SAP Knowledge Base Article - Public

1586085 - Crystal Reports that have an SQL Expression take a long time to load


  • The datasource that the report was create off of originally is not available
  • Reports with SQL Expressions can take 10s of seconds to load


  • Crystal reports 2008 (pre Fix Pack 3.4)
  • CRVS2010 (pre Service Pack 1)

Reproducing the Issue

  1. Create a report that contain an SQL Expression
  2. Remove the datasource for the above report
  3. In a VS .NET application connect the report to a new datasource


  • The Crystal Reports .NET SDK is searching for the original database on the Load Report event


See Also

  • Reference escalation number; ADAPT01496545


slow fast slower change different datasource CR2010 2010 CR4VS2010 CR4VS VS2010 NET2010 crystal reports for visual studio 2010 , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem


Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio