This is a migrated thread and some comments may be shown as answers.

Exporting Report Issue.

4 Answers 180 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Nauman
Top achievements
Rank 1
Nauman asked on 22 May 2014, 11:52 AM
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

4 Answers, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 27 May 2014, 07:00 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Nauman
Top achievements
Rank 1
answered on 27 May 2014, 07:50 AM
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





0
Nasko
Telerik team
answered on 29 May 2014, 02:18 PM
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:
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Nauman
Top achievements
Rank 1
answered on 30 May 2014, 04:30 AM
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
Tags
General Discussions
Asked by
Nauman
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Nauman
Top achievements
Rank 1
Share this question
or