July 31, 2012 at 12:36 am
i have developed two dump reports in ssrs 2008 r2. in that report one report have 31 columns and rows in 4 lacks. sec report have 62 columns and 4 lacks rows.
when ever i had excuted in sql server those related queries are working fina.
when i had run those reports it showing error(out of memory exception).
could you please tell me.
how to solve above issue.
July 31, 2012 at 10:43 am
I am not sure of the quantity represented by a lack, but I believe it is a pretty large number. You also say "Dump report." Is this a data feed to something else or for an analyst to use as a data source or a report? If it is a report, then I would say the only way to fix your problem is to increase capacity on your server, or reduce the number of rows returned. If it is just a data feed, move the whole thing to SQL Server and forget about SSRS in this instance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply