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
Who is Participating?
Accpac_AttackConnect With a Mentor Commented:
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!
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?

IT_TechnoAuthor Commented:
Will confirm and advise
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.

All Courses

From novice to tech pro — start learning today.