Hi,
Few things while exporting to Excel.
1. All objects should have same height.
2. Do you specified border for the objects?
3. In the main report, turn off the borders on the subreport.
4. If the subreport is not on demand subreport the object which you are using for display should have same size as your main report objects.
5. In the subreport, go to File>Page Setup and set ALL of the margins to 0.
6. In the subreport, suppress all sections except the one that contains your data.
Try to export the report as MS Excel (97-2003) format(Page based).
I have googled and found that " When we have a sub report and exporting to excel it will take one blank line. This is by design."
Edited by praveeng - 19 Jun 2013 at 10:57am