March 4, 2014 at 2:45 pm
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?
March 4, 2014 at 2:49 pm
At 1000 pages, SSRS just seems the wrong tool for the job.
A clever .NET program will probably be more efficient.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply