I have a report that is supposed to render 3 million plus rows, but it just says loading and stays there. I created a snapshot which took 2hrs to create, but I still couldn't render it from the snapshot. the report just stayed at loading. The query for the report only takes 9 secs to execute and display the data in SQL Management studio. I can't use paging, cause I have to render it in a single grid, so that the user can export to excel. If paging is used only the current view can be exported to excel. We have SSRS servers in NLB with 24 GB of ram, 64-bit. How can I check what is going on with the report rendering? Here' the error I get on the report page after it fails to display the error ********************************************************************************************* Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET4.0C; .NET4.0E; .NET CLR 3.5.30729; .NET CLR 3.0.30729) Timestamp: Fri, 17 Jun 2011 21:31:20 UTC Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12002 Line: 5 Char: 62099 Code: 0 URI: http://ssrsreportserver/Reports/ScriptResource.axd?d=UIobHjPy9tKgwVfWdTFZMGl5QXD15rC_OO-ztwqLhBsFXldnD8M73RNm7tdoJMi2lxcdN1vFvfJbEqw3WZkm7epqE8RQ6Gh0PgP968xa7kAOTmIeSA5lEw5rQjeny5LcrCTD_YRzvLWQbwAooB6Tn_IC5Rc1&t=5c2f384e ******************************************************* In the event viewer I get the following error "Report Server (MSSQLSERVER) cannot load the SQLPDW extension." with an error id of 108 any help appreciated.

Sounds to me like there might be a requirements gap here... what user can actually absorb 3 million rows? Or are these reports being written out for audit and compliance purposes? It would make more sense to me to understand what the users are doing with that data (e.g. in Excel) and try to find ways to support that rather than to fix the specific issue you're dealing with right now (which seems like it must be scale related to some degree). If the information workers you're enabling with this data are looking to do their own dynamic summaries, I'd recommend looking at the possibility of building an Analysis Services cube over the 3 million rows concerned, then publish that cube out to Excel-driven data consumers via Excel Services in SharePoint. Cheers Jeremy Huppatz Managing Consultant: Solitaire Systems

Hi, From your description, you need to display 3 million plus rows in one report page but it always fails. So, I would first recommend you read the MSDN document Processing Large Reports (http://msdn.microsoft.com/en-us/library/ms159638.aspx). If it doesn’t work, please post the recent records in the Reporting Services log file. I also noticed you need to export the report to Excel, please be advised that the maximum number of rows in a worksheet is limited to 65,536. But if use page breaks, each report page can be exported to separate worksheet. For more information about Excel Limitations, please refer to http://msdn.microsoft.com/en-us/library/dd255234(v=SQL.100).aspx For the error in the event viewer, please refer to the similar thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/34b2f6c4-a6a2-43bd-a349-ebab5b8d92f0 Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Tony and Gedulous, Thank you for the answers. The reports are for audit and compliance purposes. The information you shared is very helpful.