When creating a .csv report with the Knowledge Portal, the default encoding is in Unicode. Opening the .csv with the Japanese version of Microsoft Excel by double clicking on the .csv file, each line in the .csv report populates only the first column in Excel, rather than each column.
The Japanese version of Excel opens .csv files with S-JIS encoding by default. When the .csv file is in different encoding scheme, the characters set does not match S-JIS, so the above issue occurs.
Is it possible in Knowledge Portal produce .csv reports in a different encoding (ie. S-JIS) other than Unicode?
There is a limitation with the encoding with .csv files that Microsoft's SQL Server Reporting Console can produce and how Microsoft Excel will recognize and open a file.
SQL Server Reporting Services 2005 is limited to the following character encoding schemes: ASCII, UTF-7, UTF-8, or Unicode. The default value is Unicode.
1. Open Excel
2. In Excel, click File | Open
3. Locate the .csv report.
4. In the Text Import Wizard, change the File Origin to UTF-8 and complete the steps in the wizard.
Waiting for fix in a future release of Microsoft SQL Server Reporting Services.
Refer to Microsoft SQL Server 2005 Books Online (September 2007) - "CSV Device Information Settings" http://technet.microsoft.com/en-us/library/ms155365.aspx