• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

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