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
Posted Tuesday, March 4, 2014 2:45 PM


Group: General Forum Members
Last Login: Friday, November 20, 2015 1:44 PM
Points: 107, Visits: 264
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:

".... 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



Group: General Forum Members
Last Login: Today @ 8:28 AM
Points: 14,838, Visits: 12,892
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 SQLKover.

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

Add to briefcase

Permissions Expand / Collapse