I am getting 'System.OutOfMemoryException' error when running a report which is created of an rdlc file. The report is suppose to return over 34K recordsand 23 fields Is there a solution

Please check following link, http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/26a8ef98-1ed9-44f3-8617-b123fc4cb831/ Or http://blogs.msdn.com/b/selvar/archive/2008/07/18/getting-system-outofmemoryexception-when-using-reportviewer-contol-in-local-mode.aspxGaurav Gupta http://sqlservermsbiblog.blogspot.com/

Please check following link, http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/26a8ef98-1ed9-44f3-8617-b123fc4cb831/ Or http://blogs.msdn.com/b/selvar/archive/2008/07/18/getting-system-outofmemoryexception-when-using-reportviewer-contol-in-local-mode.aspxGaurav Gupta http://sqlservermsbiblog.blogspot.com/

But these links do not explain the root cause and the solution. These are suggestions. I have a seperate Web Server on which the ReportViewer Control is installed and the data is sitting on a seperate server. What i am interested is: 1. What would cause this error? Is the error indicating the issue with the server memory or ReportViewer Control memory? 2. How to find out/monitor the memory allocation and consumption of the ReportViewer Control? 3. Using the HTTP Compression on IIS would be helpful to avoid these errors? 4. Restarting IIS would resolve the issue temporarily? But, what is that restart of IIS releasing which eventually builds up and the issue reappears? 5. Is there a solution posted by Microsoft which has proved to be working? Thanks, Sharad

Response, with possible solution, would be greatly appreciated. Sharad