Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS ISSUE Expand / Collapse
Posted Tuesday, July 31, 2012 12:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 25, 2015 1:02 AM
Points: 926, Visits: 689
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.

Post #1337683
Posted Tuesday, July 31, 2012 10:43 AM


Group: General Forum Members
Last Login: Wednesday, September 16, 2015 10:17 AM
Points: 2,829, Visits: 2,606
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.
Post #1338044
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse