CODEWITHSUNDEEP
c#asp.netcrystal-reportsreportviewer
James213
James213

Reputation: 977

Crystal Report Viewer takes a very long time to run

So i've inherited a web application that is using crystal reports to display our reports. I've found that the performance of running a report on the web app too way too long(in come cases over 2-3 mins.)

I have broken down all of the components of the application to find where the data was bottle-necking and it turns out that its the crystalreportsviewer. It is only taking 1-2 seconds to run the stored procedure in the database and at most 4-5 seconds to get the results of our data in our web services. But when i go to run the report using crystal it takes several minutes.

What i would like to know is if there is some kind of bug occurring in the crystal reports viewer or if someone would have any idea on how to go about speeding up the time it takes to load a report using the crystal reports viewer?

I've looked around quite extensively for the answer to this problem which included making changes to the .net framework But i was hoping for some insight regarding crystal reports itself as to why this occurs.

any help of suggestions would be greatly appreciated. Thank you.

Upvotes: 1

Views: 5164

Answers (1)

HichemSeeSharp
HichemSeeSharp

Reputation: 3318

Crystal reports takes a long time to load its DLLs at the first time you call a report. What SAP suggests is to load a dummy report at the first app excution using a thread or a background worker to get DLLs ready when calling your production reports. Hope it helps.

Upvotes: 2

Related Questions