Not answered CSV export missing table data

Mark

Posted on Apr 23, 2009 (permalink)

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?

Reply

Mark

Posted on Apr 24, 2009 (permalink)

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?

Reply

Daniel

Posted on Jul 15, 2009 (permalink)

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.

Reply

James Strope

Posted on Mar 11, 2010 (permalink)

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.

Reply

Gersh

Posted on Mar 11, 2010 (permalink)

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

Reply

Daniel

Posted on Mar 12, 2010 (permalink)

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

Reply

rakesh

Posted on Nov 22, 2011 (permalink)

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

Thanks Rakesh

Reply

Related resources for "CSV export missing table data"

.NET Developer Tools DevTools