1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Apr 2013
    Rep Power

    Crystal report loads slowly with huge data. Can we make crystal report display report

    I have visual studio .net 2002 professional edition installed on my computer with crystal report version 9.1. An application is generated using the above tools, the problem is crystal report loads slowly (not all crystal reports in the application but only one or few which displays huge data)
    I have checked the crystal report SQL query and executed the same on SQL server. Even SQL server query gets successfully completed after 2 to 3 min. This query is returning huge data which is required.
    SQL query shows data page by page until the last page is displayed but crystal report displays huge data only after retrieving the complete data.
    Is there any solution which can be used so that crystal report shows the huge data quickly or at least shows the data page by page as soon as the view button is clicked or as soon as the report is loaded?
  2. #2
  3. Alter Ego Wizard
    ASP Genius (4000 - 4499 posts)

    Join Date
    Jun 2004
    Edinburg Tx
    Rep Power
    By huge data do you mean that there are many pages in the results?
    Or does the report take too long to execute?
    If the latter is true, click on File -> Report Options -> uncheck "Save data with report" and uncheck "Verify on First Refresh"
    ................... ASCII and ye shall receive ..................
    Knowledge is the only resource on earth that multiplies when shared

    Support the Shemzilla Project
    Powered by C#
  4. #3
  5. No Profile Picture
    Registered User

    Join Date
    Jun 2013
    Rep Power
    Post your code.
  6. #4
  7. No Profile Picture
    Registered User

    Join Date
    Dec 2013
    Rep Power
    This information is very constructive for correct planning. I like your work for providing information to the other.

Similar Threads

  1. Bypass Crystal Report Viewer/Display Report
    By wpoopsi in forum ASP Development
    Replies: 0
    Last Post: May 28th, 2009, 03:40 PM
  2. Crystal report error : crystal report job failed
    By yasinirshad in forum .NET Development
    Replies: 1
    Last Post: October 6th, 2008, 01:47 PM
  3. Crystal report... How to Print Crystal report using PrintDocument??
    By angela09 in forum Visual Basic Programming
    Replies: 5
    Last Post: September 22nd, 2008, 11:39 AM
  4. Replies: 0
    Last Post: June 22nd, 2004, 10:49 PM
  5. Replies: 0
    Last Post: June 22nd, 2004, 10:48 PM

IMN logo majestic logo threadwatch logo seochat tools logo