SAP Knowledge Base Article - Public

1839148 - Crystal Reports based on Oracle takes a long time to execute.

Symptom

  • Crystal Reports takes a long time to refresh.
  • The queries running at the backend causes reports take long time.

Environment

  • Crystal Reports 2008
  • Oracle 10g & 11g

Reproducing the Issue

  1. Create a database with more than 1 schema owner.
  2. Create a new crystal report using a native connection and connecting to the database using a schema owner login.
  3. Drag and drop some fields into the database.
  4. The report takes long time to refresh.
  5. Trace Oracle; the trace should show the SQL query run in the back end from Crystal Reports.

Cause

The issue was raised to the Product Group under ID ADAPT01490944.

Resolution

The behaviour is by design.

Workaround:

The number of queries that are being executed at the backend can be reduced by un-checking the option Verify On First Refresh and Automatic Smart Linking under the option File -> Options -> Database.

Keywords

CR performance issue, back end query running Crystal Reports. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011