You must Sign In to post a response.
  • Category: ASP.NET

    Crystal report taking long time to load

    crystal report taking time to load

    Hi All,

    I have developed report using crystal report, here i'm facing performance issue.
    In local it's taking 10 mins to load but in production it's taking more than 40 mins to load.

    kindly guide me how to overcome this issue in production environment.

    Thanks in advance.
  • #762461
    Hello Rajan,

    Crystal Report takes time to load while you are putting data from database.

    Reasons :
    --> Your server may take time to transfer data
    --> Your report may needs too much data

    So these can be the reasons due to this your crystal reports taking too much time to generate.

    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #762466
    Hi Rajan,

    To evaluate time, download live data and restore in your local and then execute that in local environment and then check the time logs, if it's take more time then execute the procedure which you created to bind it for report, check the time being how long it's taking to execute the query, if it's take more time then optimize the query and rerun.

    Give respect to your work, Instead of trying to impress your boss.

    Blog :

  • Sign In to post your comments