We are using SSRS 2000.
I can make the .csv file format correctly with blank lines when I put in the URL a suffix of:
..&rs:Format=CSV&rc:SuppressLineBreaks=True
I wanted to try to change this in the config file and have the RSreportServer.config file @:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
I've made the following changes and restarted both IIS and the Reporting Services service itself and no luck:
<!--<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
<SuppressLineBreaks>True</SuppressLineBreaks>
</DeviceInfo>
</Configuration>
</Extension>
I can make the .csv file format correctly with blank lines when I put in the URL a suffix of:
..&rs:Format=CSV&rc:SuppressLineBreaks=True
I wanted to try to change this in the config file and have the RSreportServer.config file @:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
I've made the following changes and restarted both IIS and the Reporting Services service itself and no luck:
<!--<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
<SuppressLineBreaks>True</SuppressLineBreaks>
</DeviceInfo>
</Configuration>
</Extension>