Exporting Report Issue.

[Nauman]

I am using Q1 2014 telerik controls and  i am having a problem in exporting my report to CSV format.
As my exporting language is 'Thai' but after exporting it is giving me garbage values. Please find the attachment to have a clear look.
Previouslly I wasnt having this issue. As i was using the telerik reports but with previous version.

any help would be Appreciated.


Best Regards,
Nauman Usmani

[Nasko]

Hello Nauman,

Some versions of Microsoft Excel treat the CSV files as ANSI-encoded by default, which causes the incorrect display of the text. You can read more about this behavior and how to change it in the following forum thread: Exporting Report to CSV Issue.

Regards,
Nasko
Telerik

 

 

[Nauman]

thanks for your reply Nasko,

1. i have done my search and i have found out the same things you have told in your post. i have also written my own custom code for code behind but this changes my functionality. 

2. In short your saying to shift on Q3 2013 to achieve this functionality ?


3. I have tested this on Q1 2014 sp1 8.0.14.507 but there seems the issue is still there. well i don't want to downgrade my application to later versions and don't want to change my functionality by writing custom code. 

4. Open CSV file via Export in excel is not a better option. 

5. how can i achieve the old functionality on telerik report button save and export as a CSV ? 

6. the solution should be via using telerik default behavior. ?

it will be very thank full from you to provide me with a solution. 

Regards,
Nauman Usmani

[Nasko]

Hello Nauman,

You don't need to switch to an older version of Telerik Reporting to achieve the desired functionality.
In order to get the same behavior in Excel as before, you need to set the following CSV Device Information Settings in your application configuration file:

• WriteBOM = True
• Encoding = UTF-8 (or other code page identifier)

Additional information on how to add the settings to the application configuration file can be found in the Telerik Reporting Configuration Section help article.

In case you need further help, please open a support ticket, where you can zip and attach a runnable sample project with test data exhibiting the issue.

Regards,
Nasko
Telerik

 

 

[Nauman]

thank you for your reply, i have added this in my configuration file and the problem was solved.  i have added follwing line in my configuration and the CSV export in doing great.
<Parameter name="WriteBOM" value="true"/>

thank you.

Best Regards,
Nauman Usmani