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

export Excel or CSV

4 Answers 269 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Sebastien AUROUX
Top achievements
Rank 1
Sebastien AUROUX asked on 22 Oct 2012, 01:53 PM
Is it possible to export only the data, for example if i have a table set in the report as following

Column1 Column2 Column3
xxx1 xxx2 xxx3
yyy1 yyy2 yyy3
zzz1 zzz2 zzz4

i would like to have the following csv :
Column1,Column2,Column3
xxx1,xxx2,xxx3
yyy1,yyy2,yyy3
zzz1,zzz2,zzz4

for the moment i have some textbox string that appear in the csv and i do not know how to get rid of them.

thanks for your help
sebastien

4 Answers, 1 is accepted

Sort by
0
Elian
Telerik team
answered on 24 Oct 2012, 12:34 PM
Hi Sebastien,

Try using NoStaticText CSV Rendering setting which will exclude all static TextBox items. Also column names in the CSV are generated from the names of the TextBox items containing the value. So try naming the TextBox items that contain expressions to some meaningful names (instead of TextBox1, etc.)

For more information please review: CSV Device Information Settings

Regards,
Elian
the Telerik team

HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

0
Sebastien AUROUX
Top achievements
Rank 1
answered on 24 Oct 2012, 12:53 PM
Where can i do it in the report designer standalone ?
thanks
0
Zeeshan
Top achievements
Rank 1
answered on 25 Oct 2012, 09:16 AM


hi I am facing an issue i.e

I created a report using C# code.I created a blank table on report than by c# i added columns in it. Report is working fine. It also export to pdf and excel is working fine. But when I use option export to CSV it showing me the blank report.

Please help.
0
Elian
Telerik team
answered on 26 Oct 2012, 03:34 PM
Hi,

Sebastien,
You can use the Telerik.Reporting configuration section in the ReportDesigner.exe.config file. There you can configure the rendering extensions (see: Extensions Element).

Zeeshan,
We cannot tell the reason why you are getting an empty CSV document. There are several scenarios which are not handled by the CSV rendering, for example, when you have a table element in a Page Section. You can additionally look at the following thread: Dynamic Table is Empty.


Greetings,
Elian
the Telerik team

HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

Tags
Report Designer (standalone)
Asked by
Sebastien AUROUX
Top achievements
Rank 1
Answers by
Elian
Telerik team
Sebastien AUROUX
Top achievements
Rank 1
Zeeshan
Top achievements
Rank 1
Share this question
or