Reporting Service 2000 Rendering Extension. Changing Default Opti

Hi Everyone,
I'm having an issue with the CSV export in Reporting Services. The default
encoding for CSV doesn't work the best in Excel. I would like to change the
default encoding type for CSV to ASCII. It this possible?
Thanks
ChadYes it is. You need to alter the RSReportServer.config file for the CSV
rendering extension.
By default, the CSV export is in unicode, to export as ASCII then you'll
need to add some deviceinfo for the CSV rendering as follows :
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
Hope this is what you were looking for.
Phil
"Chad" wrote:
> Hi Everyone,
> I'm having an issue with the CSV export in Reporting Services. The default
> encoding for CSV doesn't work the best in Excel. I would like to change the
> default encoding type for CSV to ASCII. It this possible?
> Thanks
> Chad