SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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

Cause

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

Resolution

See Also

  • Reference escalation number; ADAPT01496545

Keywords

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

Product

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