Hi all,
we're experiencing some problems with excel export of a report containing a simple table with a huge amount of columns (55).
The exported file contains some columns with merged cells also if the content doesn't really requires it.
Reading the forum we've already had a try setting the DivideBigCells to false or disabling the table autowidth property with no results.
We've already read the How to Create Report for Export? section too, but being a simple table with no particular formats or cell placements we've found no suggestions about it.
We're using 2017.1.4 java/JS release. Can you help us?
Thanks in advance.
Here it is in attach a sample of our report with datasource data sample.
Issue exporting report to excel
Issue exporting report to excel
- Attachments
-
- Report_data.xml
- report data
- (4.2 KiB) Downloaded 290 times
-
- Report_example.mrt
- report structure
- (45.95 KiB) Downloaded 273 times
Re: Issue exporting report to excel
here it is what we have exporting to excel:
several collapsed columns having width like 0.1 (highlighted by arrows).
Once you expand one of these collapsed columns, you'll find merged cells
in attach the exported excel file
several collapsed columns having width like 0.1 (highlighted by arrows).
Once you expand one of these collapsed columns, you'll find merged cells
in attach the exported excel file
- Attachments
-
- Report_example.xlsx
- (5.5 KiB) Downloaded 260 times
Re: Issue exporting report to excel
Hello,
There are some gaps between cells in the Table component. For correct exporting, please try to use the DataBand component instead Table.
Thank you.
There are some gaps between cells in the Table component. For correct exporting, please try to use the DataBand component instead Table.
Thank you.
Re: Issue exporting report to excel
thanks for the hint Aleksey, we'll try with DataBand
Re: Issue exporting report to excel
DataBand works fine!
Thanks!
Thanks!
Re: Issue exporting report to excel
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.