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

Error when export to XML 1000 pages Expand / Collapse
Author
Message
Posted Tuesday, March 4, 2014 2:45 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 29, 2014 1:35 PM
Points: 83, Visits: 201
I need to run a report that returns 1000 pages.
First of all I realize that it's a crazy idea but the user wants it.
When it's 10-20 pages Export to XML (Save as) works fine.
When it's 1000 pages I get error:

Log:
".... An error has occurred while processing a sub-report. Details: Data retrieval failed for the subreport, 'subrpt_prj_backup', located at: /Europe Wave 3/Backup. Please check the log files for more information. Stack trace:
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.FinalizeErrorMessageAndThrow()..."


I suspect the error is misleading. It's probably a memory issue or something.
It just cannot prepare XML output for such a huge amount of data.
Am I correct?

What is the limit of output pages in SSRS?
Post #1547574
Posted Tuesday, March 4, 2014 2:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:46 AM
Points: 13,622, Visits: 10,513
At 1000 pages, SSRS just seems the wrong tool for the job.
A clever .NET program will probably be more efficient.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1547576
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse