Crystal Report hanging in report viewer

[causeidm]

So, I have a large crystal report containing about a million rows of data, 977,362 rows to be exact. Anyway, I create the query, it runs in about 7 minutes, populate the viewer, about 2 minutes, then the first page of the report displays.

This is where I run into the problem. After displaying the first page, the application hangs for about 6 hours, during this time I can't minimize the form, maximise the form, go to the next page, basically the whole thing just kind of freezes untill crystal reports finishes whatever it is doing.

Can any of you guys help me out? I don't have alot of experience with CR and I don't even know what is going on at this point that would cause everything to hang. The processor during this time is going at about 50%, so I know it is doing something.


The report is based off of a dataset containing about 4 tables with relations, it's not being narrowed down, it's a comprehensive report of everything in the database.

I am using visual studio 2007, sql server 2007, and crystal reports 9 for .net.

[mabbas110]

I will suggest that you create a parameter screen and must make sure that user gives any parameter , like date wise client wise etc , so that data can be minimized. As crystal will hang for large data what ever u do.

[causeidm]

I made a report with a range for them. but they would also like one with everything. I am used to crystal reports hanging, but for 6 hours?