Crystal Reports .net Help displaying large amount of data

[aspengal]

I have a Crystal Report .Net which displays data from a DS which is then passed on to the SQL server session.
When the number of rows in the Dataset is less (eg. 2000) then the report viewer opens correctly. But when the number of records is large (eg. 26000) then the report wont open.
I get the message:
SERVER APPLICATION UNAVAILABLE (or) UNABLE TO CONNECT TO SQLSERVER SESSION.

Please help. I want to know if there is a limitation on the Report Viewer or some settings I need to change in the web.config file?

Thank You!

 

[RTomes]

I have had this happen.
As as remember I was using an xml dataset as the source.
The report joined serveral tables. The xml was generated on the fly.

I ended up using a live data source that was a prebuilt view of what I wanted. The download went from 10 minutes to 2 seconds.

For some reason the live datasource was not what I wanted so used an xml datasource of the view instead of multiple tables and the download was about 8 seconds, which was fast enough.