I have been searching for help in exporting an SSRS 2005 report with multiple sub-reports on it to a CSV file without displaying the report to the end user. (It is basically a Download data function). Using the URL method results in a 0-length file. Using the Render method doesn't appear to support CSV files, (although one site shows how to do it).
I'm using CSV format rather than Excel format because SSRS 2005 doesn't support cell sub-reports.
Also, would it be an easier solution to install SSRS 2008 and export directly to Excel?