SQL Server Performance

Trying to use RSReportServer.config to handle .CSV

Discussion in 'SQL Server Reporting Services' started by bubberz, Apr 10, 2007.

  1. bubberz New Member

    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;
  2. satya Moderator

    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.
  3. bubberz New Member

    No, no errors ever appeared.
  4. satya Moderator

    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.

Share This Page