Hi all, I am having an Issue When export report to CSV file columns order change from SSRS 2005 to SSRS 2008. We migrated reports from 2005 to 2008 recently. How to export report to CSV file same as 2005 version. Now I am using 2008 version. Anybody can have similar issue Please help. Thanks in advance.

Hi Prabhakar, In SSRS 2005 or earlier versions, when exported a report to a CSV file format, the data was formatted in a way that preserved the way the data appeared on the report page.However,in SSRS 2008 Or later versions, CSV render behavior is changed. To workaround this issue, you can try to create a custom rendering extension which export the CSV file with 2005 version format. For the details, please refer to the following link: http://stackoverflow.com/questions/12902640/force-ssrs-2008-to-use-ssrs-2005-csv-rendering Regards, Fanny Liu Fanny Liu TechNet Community Support