export Excel or CSV

[Sebastien AUROUX]

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

[Elian]

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

[Sebastien AUROUX]

Where can i do it in the report designer standalone ?
thanks

[Zeeshan]

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.

[Elian]

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