none
SSRS 2005 Exporting to CSV Problem

    Frage

  • I export a simple report to CSV and when I open it in Excel it is all on one line with commas instead of being in columns. I have tried everything. Any suggestions? Does exporting from the report server act different than exporting from Visual Studio?

    Thanks!

    Linda


    Linda

    Donnerstag, 21. Februar 2013 20:49

Antworten

  • This is because Microsoft SSRS reports don't support a csv export to Microsoft Excel by default. You have to tell Microsoft what you really want the csv export to Microsoft to look like. 

    Here is the change you have to make:

    <!-- <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>

                                                                                    </DeviceInfo>

                                                                    </Configuration>

                                                    </Extension>


    Linda

    Donnerstag, 21. Februar 2013 23:15

Alle Antworten

  • Hi,

    On your PC, go to Control Panel, Clock Language and Region, Change Date Time and Number Format, Additional Settings then verify that

    your List Separator is a comma [,]


    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

    Donnerstag, 21. Februar 2013 20:55
  • Hi,

    When you export from your server, SSRS reads your server regional settings (like the list separator).

    If you run the same report export from BIDS on your own PC, it will assume your own regional settings.


    Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

    Donnerstag, 21. Februar 2013 21:02
  • This is because Microsoft SSRS reports don't support a csv export to Microsoft Excel by default. You have to tell Microsoft what you really want the csv export to Microsoft to look like. 

    Here is the change you have to make:

    <!-- <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>

                                                                                    </DeviceInfo>

                                                                    </Configuration>

                                                    </Extension>


    Linda

    Donnerstag, 21. Februar 2013 23:15