Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: 2 days ago @ 1:15 PM
Points: 131, Visits: 362
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: Monday, December 5, 2016 2:09 AM
Points: 15,501, Visits: 13,163
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