To start off, this pertains to Crystal Reports for Best version 8.5, but I could not find a forum specific to this software.  I have a report that takes quite a long time for users to run, ~12.5 sec.  If I run the query manually in SQL Server Query Analyzer, SS Profiler shows that both queries use the same amount of CPU and make the same number of reads, but when run in SS QA, the query take ~0.6 sec. to complete.  If I pull up the report in CR and fill it with live data, SS Profiler shows that the query takes ~6.7 sec. to complete.  What slows the query down that much in Crystal Reports?  I am not very knowledgeable on the mechanics of CR, so any help would be appreciated.  


Edited by QuikeyMan - 20 May 2011 at 10:07am

I appreciate the response, and though I could see a couple of those thoughts slowing down the overall time to generate the report, I do not understand why it would slow down the date retrieval.  Does anyone have knowledge of that sort of thing?  Can CR slow down data retrieval?

CR is to display report based on:
- direct link between tables
  depends on how we link between each table (join, left join, right join, etc.)
- views
- stored procedures
and usually these can be done from DB.

what to display is based on conditions that we apply for the report.
it can be from:
- SQL (passing parameters), or
- CR it self
  --> parameters
  --> conditions
        a. on each sections (PgHd, Details, GrpHd, GrpFt, PgFt)
        b. on some variables
  --> pictures (size of the pics)

you can check the performance of the CR from (assume you using CR XI) by clicking on 'Report' - 'Performance Timing'.

from here you can see the 'Average to to format a page' and others.



hope it help.