SSRS 2005 Exporting to CSV Problem

Question

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

Answer 1

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

Answer 2

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

Answer 3

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