February 29, 2012 at 4:32 am
Hi All,
Have you ever noted down the difference when you open a CSV file in Excel which is exported from REPORTING SERVICE 2005 and REPORTING SERVICE 2008?
The one which is exported from REPORTING SERVICE 2005 shows all the values for each row in a single column separated by comma. Whereas the one which is exported from REPORTING SERVICE 2008 shows each row values which are separated by comma in an individual columns.
For this i searched in google,i changed the reportserver configuration file like this.
<Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<Configuration>
<DeviceInfo>
<ExcelMode>False</ExcelMode>
<FieldDelimiter>,</FieldDelimiter>
</DeviceInfo>
</Configuration>
</Extension>
But still im facing the same problem after restarting the service..plz help me on this.
thank you in advance
Srinivas
February 29, 2012 at 7:18 am
Do not open CSV files in Excel.
Excel kind of screws them over. If you really want to check if a CSV file is correct, use a decent text editor, such as UltraEdit or Notepad++.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 1, 2012 at 5:06 am
The problem is that the default encoding for CSV is Unicode. Add this inside the DeviceInfo clause:
<Encoding>ASCII</Encoding>
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply