How to eliminate blank rows while exporting to Excel?
- align to top
- arrange lines
The first align to top:
- Select all fields on the row, right click, align to top
- move the selection to the top of details section (no space between the details section and the section above
- remove remaining space at the bottom of the details section
The second:
- right click details
- click on arrange lines
- right click details again
- click on fit section
This solved the issue for me.
Sometimes only the first part is necesarry.