SSRS report gives System.OutofMemoryException error

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.
SanjeetAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent DyerIT Security Analyst SeniorCommented:
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..
0
SanjeetAuthor Commented:
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.
0
ValentinoVBI ConsultantCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.