CSV export missing table data

10 posts, 0 answers
  1. Mark
    Mark avatar
    30 posts
    Member since:
    Nov 2008

    Posted 23 Apr 2009 Link to this post

    Hello,

    I may be missing something obvious here, but I've just upgraded to Telerik Reporting Q1 2009 and I'm trying to make effective use of tables. On one particular report, I've replaced an existing subreport with a table, and I'm assigning the table's datasource during the databound event of the report's detail section. I do this because the master report is populated by a generic list (List<T>) of user objects, while I need the table to reflect each user's phone numbers (which is another generic list of phone number objects contained within each user object).

    The report seems to display ok, but when I export in CSV format, the data from the table is missing.

    Do I need to assign the table datasource differently, perhaps?

  2. Mark
    Mark avatar
    30 posts
    Member since:
    Nov 2008

    Posted 24 Apr 2009 Link to this post

    OK, so I decided to play around with the Telerik Reporting samples that use the new table control, and they appear to exhibit the same behavior.

    Try the Product Catalog sample:

    http://demos.telerik.com/reporting/examples/productcatalog/defaultcs.aspx

    Export the report as CSV, and you'll find none of the data that's contained within the tables. Why?



  3. Steve
    Admin
    Steve avatar
    10942 posts
    Member since:
    Feb 2014

    Posted 24 Apr 2009 Link to this post

    Hello Mark,

    Unfortunately this is a bug and we would have to investigate it further. I'm logging it to our bug tracking database and forwarding it to our developers. Sadly there is no other workaround then reverting back to using subreport instead, until we address the issue.

    Please excuse us for the inconvenience. Your Telerik points have been updated for bringing this to our attention.

    Best wishes,
    Steve
    the Telerik team


    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.

  4. Daniel
    Daniel avatar
    16 posts
    Member since:
    Oct 2007

    Posted 15 Jul 2009 Link to this post

    Is there any news on when this bug will be solved? This bug prevents us from using the table object in a report because our reports need to have CSV export.

    NB a support ticket is opened regarding the formatting of a report. Response was to use the table object instead of docking table items but unfortunately that leaded me to this bug, hence the question.

  5. Steve
    Admin
    Steve avatar
    10942 posts
    Member since:
    Feb 2014

    Posted 15 Jul 2009 Link to this post

    Hi Daniel,

    The fix for this would be part of the upcoming service pack at the end of the month. We hope this is ok with your project schedule.

    Thank you for the patience and understanding.

    All the best,
    Steve
    the Telerik team


    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.

  6. Gersh
    Gersh avatar
    21 posts
    Member since:
    Sep 2009

    Posted 16 Dec 2009 Link to this post

    Thank you

  7. James Strope
    James Strope avatar
    17 posts
    Member since:
    Mar 2009

    Posted 11 Mar 2010 Link to this post

    Hello,

    Is there an update on this?  I am using Telerik_Reporting_2009_3_1211, and I get the same behavior.  Export to PDF and Excel work fine, but export to CSV results in an empty file.  The people above mentioned tables; in this case, there is no data of any kind.

  8. Gersh
    Gersh avatar
    21 posts
    Member since:
    Sep 2009

    Posted 11 Mar 2010 Link to this post

    Hey guys, I found the solution.
    Basically, When you give a table it's data, the cells in that table do not have access to that table's data. You manually must tell each cell in the column what the data is.

    report.column.Name =

    "DataTitle";

     

    report.column.Value =

    "=value";

     

    report.cell.ItemDataBinding +=

    new System.EventHandler(Function_to_populate_csv);

    I hope this works for you,
    Gersh

     

  9. Daniel
    Daniel avatar
    16 posts
    Member since:
    Oct 2007

    Posted 12 Mar 2010 Link to this post

    Hi Gersh,
     
    Thanks for yor answer. It pointed me into the right direction with my problem that the report table object did not export all columns to csv file. I found that not all my textboxes did have the Name property filled (my report is entirely code generated and some textbox name properties had been left unassigned with an empty string). Assigning a value to textbox.Name did the trick.

    I now get all column data exported from the table object into the csv file.

    Thanks,

    Daniel

  10. rakesh
    rakesh avatar
    1 posts
    Member since:
    Aug 2011

    Posted 22 Nov 2011 Link to this post

    When I export from report csv and excel. It get textboxes name not proper export.

    Thanks Rakesh

Back to Top