Reporting taking too long to load

[kurie]

Hi all, im using asp to load crystal reports,using this code to call the report
Session("oClientDoc").Open ReportPath. it works fine on all reports but one. its taking to long to load this report about 30 seconds.
i put a response.end after this line and it takes 30 seconds to get to resposnse.end.
does anyone know what might be causing this report to take long.
the report has one only one page, and its taking less longer to load some reports with far more records.

does anyone know what i have to do to fix this.

 

[hilfy]

There are several things that feed into how long it takes a report to run. You've noted that it doesn't have as many records as other reports that are opening faster. Here are some other things to check:

1. Make sure "Use Indexes or Server for Speed" and "Perform Grouping On Server" are turned on.

2. Try turning off "Verify on First Refresh" - this will eliminate the step where Crystal verifies the meta-data from the database. However, if there are any changes to indexes, field length, field type, etc in the tables used by the report, including new fields or indexes that the report doesn't even use, it may fail on open.

3. Try not to use Crystal formulas in your selection criteria - frequently these won't be processed on the database server, all of the data will be pulled over to where the report is being run and it will be filtered in memory.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.