Crystal Reports Perfomance problem
I have great problems with CR in my ASP.NET application.
There is too much data in database, so this cose problems with reporting.
1. All works very slow (25 minutes per report)
2. Timeout and session problems
3. Memory problems (windows kills application)
I use CR Viewer. When i click "next" button CR loads ALL data again? Is there any paging in CR to perform partial data loading? Why should i wait for 10000 pages when i want to see just one. There ia one page each time in viewer. I don't need to load page number 9000 each time!
Please, help me with this problem. My reports don't work. Clients cant wait for so long to see report! Help if you can.