Solved

SQL reports running very slow

Posted on 2011-03-18
3
287 Views
Last Modified: 2012-05-11
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
Comment
Question by:IT_Techno
3 Comments
 
LVL 4

Accepted Solution

by:
Accpac_Attack earned 500 total points
ID: 35165193
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 35165387
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
 

Author Comment

by:IT_Techno
ID: 35340381
Will confirm and advise
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now