Trying to use RSReportServer.config to handle .CSV | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Trying to use RSReportServer.config to handle .CSV

We are using SSRS 2000.<br /><br />I can make the .csv file format correctly with blank lines when I put in the URL a suffix of:<br /><br />..&rs:Format=CSV&rc<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />uppressLineBreaks=True <br /><br />I wanted to try to change this in the config file and have the RSreportServer.config file @:<br /><br />C:program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServer<br /><br /> I’ve made the following changes and restarted both IIS and the Reporting Services service itself and no luck:<br /><br />&lt;!–&lt;Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/&gt;–&gt;<br /> &lt;Extension Name="CSV" <br /> Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"&gt;<br /> &lt;Configuration&gt;<br /> &lt;DeviceInfo&gt;<br /> &lt;Encoding&gt;ASCII&lt;/Encoding&gt;<br /> &lt;SuppressLineBreaks&gt;True&lt;/SuppressLineBreaks&gt;<br /> &lt;/DeviceInfo&gt;<br /> &lt;/Configuration&gt;<br /> &lt;/Extension&gt;
Do you get any error while trying this> Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
No, no errors ever appeared.
I;m not sure with RS 2000 in this case with the compatibility of Excel, you might try with RS 2005 if you have to. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>