• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

SQL reports running very slow

I have created two reports one in crystal and one in SQL reports the crystal reports run very fast and the SQL report takes a few min to run, is there a way to speed up the sql reports
0
IT_Techno
Asked:
IT_Techno
1 Solution
 
Accpac_AttackCommented:
In Crystal, click on Database / Show SQL and compare with the SQL from the report.  Typical causes are filters on non-indexed fields or filters on calculated fileds.

Good luck!
0
 
mlmccCommented:
ARe the reports using the same datasource?

Are the reports showing similar information?

How are you connecting to the database?

Are these on the same machine?

mlmcc
0
 
IT_TechnoAuthor Commented:
Will confirm and advise
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now