Bind large amount of data to CrystalReportViewer

Question

0.00/5 (No votes)

See more:

I have a problem in my crystal report. I am fetching large amount of data and binding the same data to my report, around 20,000 pages are there. It's taking lot of time to display my first page in report.

How can I solve this problem? It's mandatory to bind all data.

Kindly help...
Thanks in advance

Posted 3-Feb-12 22:21pm

jai000

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2012-02-03T22:41:00

20000 pages?(I thought 20000 records) :omg:

I never loaded that much pages in Crystal reports, IMO that's not suggestible. Load less data based on selection criteria.

Here some suggestions regarding the performance on both sides

Database side
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]
Top 10 steps to optimize data access in SQL Server: Part III (Apply advanced indexing and denormalization)[^]
Top 10 steps to optimize data access in SQL Server: Part IV (Diagnose database performance problems)[^]
Top 10 steps to optimize data access in SQL Server: Part V (Optimize database files and apply partitioning)[^]

Crystal reports side
Report Analyzer: Optimize Crystal Reports[^]
Optimizing Report Performance[^]
Optimizing Crystal Reports[^]
Crystal Reports Slow Load Using .NET C# ( SetDataSource )[^]

Hope these will help you.

Bind large amount of data to CrystalReportViewer

1 solution

Solution 1

Add your solution here

Preview 0

Bind large amount of data to CrystalReportViewer

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us