I have a Crystal report which has the detail section suppressed - there is nothing in it anyway. I have a group footer with some summary data. It is this data the users are interested in. This footer is repeated for every change of the group value (obviously!).
When I run the report it looks lovely!

However when I export to Excel there is a blank line before every summary line.

How can I prevent this blank line in the export?