Blank lines at the end of SSRS CSV Export

Question

When exporting information from SSRS in CSV format, it always adds two empty lines after the last line of data in the exported file.

While I can edit the file after exporting and delete blank lines, is it possible to prevent SSRS from creating two blank lines in the first place?

Answer 1

See the next connection article (and vote to fix it!

Error 557655 SSRS2008 - additional empty line in csv files created by csv renderer when exporting a report.

extenstion csv RSReportServer.config. " " CSV ExcelMode false:

    <Render>
        <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>
        <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
        <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
            <Configuration>
                <DeviceInfo>
                    <ExcelMode>False</ExcelMode>
                </DeviceInfo>
            </Configuration>                
        </Extension>

Excel true. CSV- Excel Mode, . . , SSRS 2005 SSRS 2008.

Answer 2

SSRS URL- . , & rc: ExcelMode = false. .