Crystal Report running slow off a view 
Author Message
 Crystal Report running slow off a view

I have a report that is designed to pull records from a view.  The report
needs to order the data so the SQL query that is created contains an order
by.  The view takes about 16s to populate its information but the report is
taking over three minutes to run.  The view is only returning 2200 rows.
The sql query that crystal is creating looks like this:

SELECT
    Call_Table_Alias."Div_Name", Call_Table_Alias."Dep_Name",
Call_Table_Alias."Extension", Call_Table_Alias."Extension_Name",
Call_Table_Alias."Duration", Call_Table_Alias."Cost",
Call_Table_Alias."Calls"
FROM
    "CallTable"."dbo"."T_2003_06_11_REP_007662656_June_Summary"
Call_Table_Alias
ORDER BY
    Call_Table_Alias."Div_Name" ASC,
    Call_Table_Alias."Dep_Name" ASC,
    Call_Table_Alias."Extension" ASC

Any help would be greatly appreciated.  Thanks.



Mon, 28 Nov 2005 23:03:14 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Crystal Reports bug - report off new query

2. View Multiple Crystal Report as Single Report

3. Simple Report View.......Crystal Report Object

4. Viewing report created using Crystal reports 7.0

5. View a Report without Crystal Report installed ?

6. Creating RCAPI calls from Crystal Reports and viewing the report using a web application in .net

7. Got error while viewing report using crystal report

8. Landscape report views but prints in portrait (using crystal report)

9. RDC for Crystal 8: IsBusy runs slow?

10. Running Crystal 8.5 Reports on Crystal 9 RAS

11. slow printing from Crystal Reports

12. 1st Crystal Report always off-screen

 

 
Powered by phpBB® Forum Software