I have SQL 2008 R2 on 64 bit Windows 2008 box with 8 gb of RAM. I got this error when trying to preview the report in BIDS. There is one table with 1.6 million records, the report is group by SalesID for example. I thought the server we have should handle this easily. Any idea how to fix this? ThanksDon

Hi Don, Have you referred below link? http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d92a06ca-0575-4feb-b08e-a0ba94d82271 http://blogs.msdn.com/b/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx Thanks KumarKG, MCTS

Try running the report in Report Manager. BIDS is a 32 bit application and so would run into memory issues when dealing with huge datasets. 1.6 million is a lot of records by the way.

Kumar, Shahfaisal, Thanks for the tips. This is once month a report reprot user needs to run for their sales report, I deploy to the report server, it is running after 30 minutes. I am told SSRS 2008 R2 should be able to handle this type of report, I guess I am wrong. I cannot pre-aggregate in sql query since user needs to drill down for example, by salesID if detail is needed. Is adding index in the table going to help (there are 12 columns and group by salesID)? Or changing memory setting at report server? (by the way where I should go to do this? Is it still rsreportserver.config file?) Don

Is adding index in the table going to help (there are 12 columns)? It might. Use DTA(Database Tuning Advisor) to find out what indexes are necessary. Make sure that those indexes are tested first on a dev/test server.

Thanks again, I am also trying to change memory setting based on msdn link Kumar provided. it said changing WorkingSetMaximum, WorkingSetMinimum in reportserver.config file, however I don't see these two entries in my file. I do see MemorySafetyMargin and MemoryThreshold. Do I look at the wrong place? Don

Please, don't jump to any conclusions without testing/validating. How much does the query take to execute in SQL Server Management Studio? What else do you have running on the machine besides Reporting Services?

Thanks again, I am also trying to change memory setting based on msdn link Kumar provided. it said changing WorkingSetMaximum, WorkingSetMinimum in reportserver.config file, however I don't see these two entries in my file. I do see MemorySafetyMargin and MemoryThreshold. Do I look at the wrong place? Don Hi Don, This setting does not appear in the RSReportServer.config file unless you add it manually. If you want the report server to use more memory, you can modify the RSReportServer.config file and add the element and value. Valid values range from 0 to maximum integer. This value is expressed in kilobytes. When the value for WorkingSetMaximum is reached, the report server does not accept new requests. Requests that are currently in progress are allowed to complete. New requests are accepted only when memory use falls below the value specified through WorkingSetMaximum. If existing requests continue to consume additional memory after the WorkingSetMaximum value has been reached, all report server application domains will be recycled. For more information, see Application Domains for Report Server Applications. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.