RS works in memory. It is inappropriate to be using it to end up with
800,000 rows. That means that the report is not for a person, it must be for
import into someother product. Use a different technology to do this. SQL
"John K" <JohnK@discussions.microsoft.com> wrote in message
news:E0EEA041-50C0-4A39-A2B1-275EF88CFC03@microsoft.com...
> Mike / Brad,
>
> I am experiencing the same issue : "An error occured during report
> processing. Exception of type System.OutOfMemoryException was thrown". I
> can
> reproduce this both inside ReportServices IDE or through the manager. I
> have
> SP1 running on a dual CPU server with 6GB of memory and the report I am
> running has 800,000 rows. The same report with a different selection in
> the
> parameters returning less rows works fine.
>
> Let me know if you have identified a work around.
>
> Thanks in advance,
> John
>
> ""Brad Syputa - MS"" wrote:
>
>>
http://support.microsoft.com/?kbid=840709 >>
>> This article may help you.
>>
>>
>> --------------------
>> | From: "Mike Harbinger" <MikeH@Cybervillage.net>
>> | Subject: Out of memory error when running large report
>> | Date: Thu, 6 Jan 2005 18:47:55 -0800
>> | Lines: 18
>> | X-Priority: 3
>> | X-MSMail-Priority: Normal
>> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>> | X-RFC2646: Format=Flowed; Original
>> | Message-ID: <#$rvPNG9EHA.1408@TK2MSFTNGP10.phx.gbl>
>> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> | NNTP-Posting-Host: 69.106.50.114
>> | Path:
>> cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
>> .phx.gbl
>> | Xref: cpmsftngxa10.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:38909
>> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> |
>> | I have built a large report but when I try to execute inside of the
>> Report
>> | Designer, I get the following error and then an abort:
>> |
>> | [An error has occurred during report processing
>> | Exception of type System.OutOfMemoryException was thrown]
>> |
>> |
>> | I have applied SRS SP1 and here is the MSD info:
>> | Microsoft Visual Basic .NET 69457-005-1826837-18410
>> | Microsoft SQL Server Report Designer Version 8.00.878.00
>> |
>> | Running on XP SP2 with 1.25 gig RAM
>> |
>> | Is there a work-around for this?
>> |
>> | Thanks for any help!
>> |
>> |
>> |
>>
>>