I've been tearing my hair out over an issue with SSRS for weeks now (yes, weeks). I've got a fairly simple stored procedure which outputs 21 columns of data and about 160,000 rows. Just a straight up select, nothing complicated.
My issue comes with subscriptions in XML format.
Under SSRS 2008 these don't work with the error 'Failure writing file An error occurred during rendering of the report.'
If I make some of the columns null instead of pulling data from a table I can get it to run successfully.
Under SSRS 2012 the same procedure works exactly fine, a subscription gives me the results I need in xml format.
The fact that 2012 works fine makes me think it's not an issue with the data, however, I just can't get around the issue in 2008.
Has anyone encountered similar?