Crystal Reports takes a long time to refresh.
The queries running at the backend causes reports take long time.
Crystal Reports 2008
Oracle 10g & 11g
Reproducing the Issue
Create a database with more than 1 schema owner.
Create a new crystal report using a native connection and connecting to the database using a schema owner login.
Drag and drop some fields into the database.
The report takes long time to refresh.
Trace Oracle; the trace should show the SQL query run in the back end from Crystal Reports.
The issue was raised to the Product Group under ID ADAPT01490944.
The behaviour is by design.
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.
CR performance issue, back end query running Crystal Reports. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem