System.OutOfMemory in SSRS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

System.OutOfMemory in SSRS

Author

Topic

sanghavi17389
Starting Member

26 Posts

Posted - 2012-05-17 : 08:12:45

I am using SSRS 2008 for reporting.
I made a matrix report but when I preview it that time it shows error of System.OutOfMemory.
My total records are 50,000 around.
I added the parameters to do filter so less data can be loaded but still I am getting System.OutOfMemory exception.

Please help me for the solution

harshal sanghavi

edit: moved to proper forum

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2012-05-17 : 08:40:05

Check this out:

http://support.microsoft.com/kb/909678

Vijay is here to learn something from you guys.

sanghavi17389
Starting Member

26 Posts

Posted - 2012-05-17 : 09:01:16

Any other solution?

harshal sanghavi

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-05-17 : 09:15:40

What are the system specs of the server you are running this off of?

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources