Telerik Report - empty rows between each record

[jayanthi]

Hello,

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...

How to avoid blank rows? Its urgent.

Thank you
Jayanthi

[IvanY]

Hi Jayanthi,

When your report is going to be exported to Excel you have to know that the reporting engine will try to reproduce as much of the original report as possible regarding layout and styling. However because of this there might be some other undesired limitations, such as blank rows and merged cells. In order to get rid of them you have to redesign the layout of your report. For more information please check our Design Considerations for Excel Rendering help article.

I have attached two report definitions that have good and poor excel output. The main things you have to look for:

1. Space between textboxes and items in general. Items have to be aligned and next to each other, otherwise free space will not be randomly ignored and will be rendered as empty columns/rows. 
2. Space between the containing section (for example the detail section) and the items - this empty space will not just be ignored randomly - it will be rendered as empty columns/rows. 

If you still experience issues with making a report Excel friendly you can send us a report definition so that we are able to help/advice you more accordingly.

Kind regards,
IvanY
the Telerik team