export Excel or CSV

5 posts, 0 answers
  1. Sebastien AUROUX
    Sebastien AUROUX avatar
    34 posts
    Member since:
    Sep 2008

    Posted 22 Oct 2012 Link to this post

    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
  2. Elian
    Admin
    Elian avatar
    435 posts

    Posted 24 Oct 2012 Link to this post

    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!

  3. DevCraft banner
  4. Sebastien AUROUX
    Sebastien AUROUX avatar
    34 posts
    Member since:
    Sep 2008

    Posted 24 Oct 2012 Link to this post

    Where can i do it in the report designer standalone ?
    thanks
  5. Zeeshan
    Zeeshan avatar
    1 posts
    Member since:
    Oct 2012

    Posted 25 Oct 2012 Link to this post



    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.
  6. Elian
    Admin
    Elian avatar
    435 posts

    Posted 26 Oct 2012 Link to this post

    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!

Back to Top
DevCraft banner