April 4th, 2013, 07:24 AM
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?