I designed a report in 2014 Q1. When I export is to excel huge number of empty rows are generated. Report contains Page Header Section1 and Details section1. Currently detail section is empty.Please refer my screen shots. How to solve this problem.
Please ignore "Report contains Page Header Section1 and Details section1. Currently detail section is empty" these sentences in my thread..
0
Stef
Telerik team
answered on 25 Mar 2015, 03:40 PM
Hi Harsha,
In Excel format reports are rendered based on the Design Considerations for Excel Rendering. The exported report will look as close as possible to the preview in the viewer. Test setting the Style.BackgroundColor to all sections to check where the report ends.
Feel free to open a support ticket and send us a demo report to check your settings.