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
Author
Message
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: Wednesday, September 3, 2014 9:44 PM
Points: 888, Visits: 671
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 12:48 PM
Points: 2,818, Visits: 2,566
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