Is there a simple way of getting a report layout that exports very well to excel. In Crystal, I was able to simply align columns to the fields in detail. When I do it in Jaspersoft, the columns get truncated and the detail fields are in the wrong column.
You can use Table and Crosstab components which will export to Excel very well.
If you cannot use these components for some reason, you can use horizontal grid formatting on the Detail band so that it will export without blank columns or merged columns.