sql server reporting services: Hi

I wish to export a reportas CSV format, however when I open it in Excel it is assuming it is fixed width seperated, when it clearly is comma seperated! Is there any way I can get it to do it right?

I am using Excel 2000 to view the csv output, and it is being triggered via a URL on a ASP.NET application.

Thanks for any help.

Jan

*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=0388cedae91e417186f2d4a5cdfc8406

I have answered my own question, by applying the parameter

rc:Encoding=ASCII

to the URL!

*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/5264
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=6357bd9e0da54182b1994c9908ce943b