CSV export missing table data

[Mark]

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?

[Mark]

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?

[Steve]

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.

[Development]

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.

[Steve]

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.

[Gersh]

Thank you

[James Strope]

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.

[Gersh]

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

 

[Development]

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

[rakesh]

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

Thanks Rakesh