Crystal Reports on ASP.NET: How to make the first page visible faster

950 Views Asked by At

In ASP.NET application, while using Crystal Reports (using the Report Viewer control), the report is visible (or the data in the report) only after the complete data is bound to the report source. If the data is too huge (spanning 50 or hundreds of pages), the data binding takes a while. Can there be some technique to better the perceived speed by making the first page data visible as the data for the first page is bound? The rest of the data can be bound by the time the user sees the first page.

1

There are 1 best solutions below

3
On

paginate the sql query for resultset to bind first page only to the report.

http://josephlindsay.com/archives/2005/05/27/paging-results-in-ms-sql-server/