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 2005 Forums
 Analysis Server and Reporting Services (2005)
 Is there a row limit?

Author  Topic 

bushfoot
Yak Posting Veteran

53 Posts

Posted - 2009-02-12 : 12:13:34
I have an rdl doc that basically represents a phone bill.

It has 119 000 rows on it. When I run it from the preview tab a report project I get an Out of Memory error.

"An error occurred during local report processing. An error occured during rendering of the report. Exception of type System.OutOfMemoryException was thrown"

This is a matrix report. Are there row limitations to this?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-12 : 12:21:17
Do you recent Service packs and patches in your server as well client machine?
Go to Top of Page

bushfoot
Yak Posting Veteran

53 Posts

Posted - 2009-02-12 : 12:50:53
This is a visual studio 2008 Business Intelligence Report project. I have an rdl doc that hits the db and pulls 119 000 rows. When i go to the preview tab of the rdl doc and hit preview, I see in profiler the proc get executed but before the report gets generated I get the out of memory error.
And my answer to the age old questoin "what changed?" is nothing... or at least nothing to my knowledge :)
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-12 : 13:03:22
quote:
Originally posted by bushfoot

This is a visual studio 2008 Business Intelligence Report project. I have an rdl doc that hits the db and pulls 119 000 rows. When i go to the preview tab of the rdl doc and hit preview, I see in profiler the proc get executed but before the report gets generated I get the out of memory error.
And my answer to the age old questoin "what changed?" is nothing... or at least nothing to my knowledge :)



You didn't answer my question. I guess it was fixed in recent SP.
Go to Top of Page
   

- Advertisement -