Dear Forum Members,

Our application is built upon .Net Framework 2.0 and we are using Crystal Report 11 for generating/displaying reports.

Very recently we noticed that, if the amount of data is huge (roughly above 4000 records), crystal report is not able to bind it the report viewer and the entire application is getting hanged. As an alternative we thought of exporting the report into PDF and display it using Acrobat reader. But even that was failed too. With this huge amount of data the Export is also not happening and again the application is getting hanged.

I googled through the net but didn’t found a solution to this.

Please suggest how to resolve this problem.

Please note few points:
===========================
** We are using VS2005 with SQL Server 2000.
** We are using Datasets for the report source.
** With small amount of data we really don’t have any problem and it is loading it properly.
** For those reports, which are creating this problem, we cannot reduce OR filter the data as they are yearly reports and will involve huge amount of records (roughly more than 10K at production)
** We cannot bind our report to a Stored Procedure as our architecture will not support that.

I agree with Iago's post. There are ways to test the performance on the client side and server side to see where the bottleneck is. Also, use a stored procedure in SQL to return the data if possible.