Hi i have a requirement where i have to create a report for like 6.8 million record all the records should be aggregated and should put them in the report and render that to a PDF, the report was runnign fine( i am doing it on preview mode in Business Intelligence development Studio 2008) but when i render it to PDF i am getting an out of memory exception , i saw there is a 160 page limit for PDF rendering but my report has like 30 pages MAX i dont understand why the rendering has a Out oF memory could some one please help me out with this thanks

It seems your report server does not have enough memory to suport the operation.

It seems your report server does not have enough memory to suport the operation. Is there any way i can increse the memory on the report server so the rendering can go fine.

What are your server specifications? CPU, RAM, Windows, SQL Edition?

Hi, Reporting services has a MemoryThreshold, which specifies a percentage ofWorkingSetMaximum that defines the boundary between high and medium pressure scenarios, if you rendering large amount records, you could also configure settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum,MemorySafetyMargin, and MemoryThreshold. Configuration settings are specified in the RSReportServer.config file. For more information about Configuring Available Memory for Report Server, please see: http://msdn.microsoft.com/en-us/library/ms159206.aspx Hope this helps. Regards, Charlie Liao

Hi, Reporting services has a MemoryThreshold, which specifies a percentage ofWorkingSetMaximum that defines the boundary between high and medium pressure scenarios, if you rendering large amount records, you could also configure settings that control memory allocation for the report server include WorkingSetMaximum, WorkingSetMinimum,MemorySafetyMargin, and MemoryThreshold. Configuration settings are specified in the RSReportServer.config file. For more information about Configuring Available Memory for Report Server, please see: http://msdn.microsoft.com/en-us/library/ms159206.aspx Hope this helps. Regards, Charlie Liao will try this