Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Reports Running Very Slow

Dear all,

I am not sure if it is by adding alot of tables into the report database or is it because of the formula or anything else but two of my reports are running really slow these days.

Both of the reports hold 7 tables altogether with 5 parameters of which 2 are dynamic. When I press F5 on my report sometimes it takes 1mins to load and some times good 5mins. Similarly while processing it takes from 6mins to good 15mins.

(Like now I ran the report for June month since 15:39 it is still running and now its 15:58 and it has finally loaded)

I simply do not understand why would the report take so long to load.. Once it load quicker and I checked the performance under Report performance and it stated 626ms Generate page, 2ms for formatting page.

On my recent attempt it states

Run the database query - 87238ms

Read database records - 30691ms

Format First Page - 981428ms

Average time to format page - 327143ms

Average time to generate a page - 58980ms

Time to format all charts (there is only 1) - 332014ms

I have similar reports with 6 tables and 4 parameters however they take flick of an eye and produces the results.

Is it to do with indexing on the database server? or my report coding has issues or something else?

I am using Crystal Reports 2008, ODBC connection to Informix Database 7.3.

Please advise on this

Regards

Jehanzeb

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question