I followed the wizzard and made no changes to the report layout besides what the wizzard did and when I export to Excel there are two extra blank rows between every row of data. What is causing this?
The report has a labels group header and detail...
The report has a labels group header and detail...
4 Answers, 1 is accepted
0
Hello Mike,
We leave some space on top and on bottom of the items by design. You can easily remove it by zooming and making sure all items "fit" exactly to the details' section top and then squeeze its bottom to the items' bottoms.
As you know we are currently working on crosstab/table item and once it is ready, we would modify the report wizard to use table directly to avoid such inconsistencies.
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.
We leave some space on top and on bottom of the items by design. You can easily remove it by zooming and making sure all items "fit" exactly to the details' section top and then squeeze its bottom to the items' bottoms.
As you know we are currently working on crosstab/table item and once it is ready, we would modify the report wizard to use table directly to avoid such inconsistencies.
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.
0
Mark
Top achievements
Rank 1
Rank 1
answered on 07 Oct 2014, 11:20 PM
I have zoomed in to 400% and have tightened up my fields in the Details section to where it looks as tight as it can be and I'm still getting extra rows in Excel when I export. Is there another trick involved?
0
Mark
Top achievements
Rank 1
Rank 1
answered on 07 Oct 2014, 11:31 PM
Also, there are many, many columns separating the data fields. How do I eliminate those?
0
Hello Mark,
Please check the suggestion in the Design Considerations for Excel Rendering article under Merging Cells.
If yuo need further help, feel free to open a support ticket and send us details about the used Telerik Reporting versions, the report code files, including test data to run them.
Regards,
Stef
Telerik
Please check the suggestion in the Design Considerations for Excel Rendering article under Merging Cells.
If yuo need further help, feel free to open a support ticket and send us details about the used Telerik Reporting versions, the report code files, including test data to run them.
Regards,
Stef
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.