SSRS report gives System.OutofMemoryException error

Posted on 2013-10-02
Medium Priority
Last Modified: 2016-02-11
I have a report that uses a stored procedure.

I added a parameter called batchno which is an  integer.

The SQL works fine in the database. When I use the report with the same data value I get the System.Outof memory Exception message.

I re-created the report several times. In the parameters section I ensured the parameters appear. In the data section the parameters appear.

The batch parameter is a nullable value and set to null in the DB and in the report before running.

and (PRB.BatchNo = (@BatchNo) or @BatchNo is Null)

Not sure what the problem is.
Question by:Sanjeet
LVL 17

Expert Comment

by:Kent Dyer
ID: 39541060
Not knowing how you configured SSRS..  Is this version 1.0 or 2 or 3?

Part of the issue that  I can see is that if you are trying to export millions of rows into SSRS, it would make sense.

Have you considered creating a nightly/monthly extract and have SSRS e-mail the results to you?  Another idea that comes to mind is creating a view that captures the data you need.  Another issue that comes to mind is that if you use a COUNT(*) in your SQL Queriy, you may want to use COUNT(1) instead..

Author Comment

ID: 39543262
Where do I find out what version I  have. I am on VS 2005.

The rows are about 90,000 not a million.

Multiple people need to run the report with different parameters values therefore the nightly email will not work.
LVL 37

Accepted Solution

ValentinoV earned 1100 total points
ID: 39550503
90,000 records is still a lot for a report.  What are you doing with that data?  If it's just getting summarized in the report then I'd consider summarizing in the SP before sending it to SSRS.

And if it's not getting summarized then I think you should look into other export options (SSIS for instance).  A table in SSRS isn't of much use, people are really not going to read all those one by one.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package). The latter is certainly a headache for developers, particularly for me. We had to ma…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question