asked on

How to removed commas below the headings from SSRS csv export report.

From SSRS when export a blank report to CSV, I'm getting a line of commas below the headings.

SSRS report Output
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D
,,,,,,,,,,,,,,,,,,

I'm looking for output without commans
SSRS report Output
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D

------------------------------------------------------------------------------------
My rsreportserver.config setting is as below
            <Render>
                  <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                        <Configuration>
                              <DeviceInfo>
                                    <Encoding>ASCII</Encoding>
                              </DeviceInfo>
                        </Configuration>
                  </Extension>
            </Render>

Arifhusen Ansari

If your report donot have data. It must show only header and in that case your exported csv won't have row like ',,,,,,,,,,,,'.

Your might not be blank but report has rows with blank as a data like. SO it's having a row like ',,,,,,,,' when you export the report.

Bharat Guru

ASKER

If I execute the sp manually the result is blank. If I run the same report with Microsoft SQL Server 2012 (SP3) I'm not getting ',,,,,,,,,,,,' but If I run the report from Microsoft SQL Server 2012 (SP2) I'm getting ',,,,,,,,,,,,'

ASKER CERTIFIED SOLUTION

Arifhusen Ansari

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bharat Guru

ASKER

CSV generated from ssrs with SP 3
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D
,,,,,,,,,,,,,,,,,,

CSV generated from ssrs with SP 2
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D

Bharat Guru

ASKER

Thanks