• I'm not sure, but if I read your problem it looks like a limitation in XML-size. Maybe there is a property in SSRS (like there is in SSMS) to set the size of a XML?

    You mention it works when you alter column values to NULL. Does it also work if you limit the rows in the resultset (example: 100,000 instead of 160,000)?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **