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:
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?