AFAIK, there is no way to do this. Formatting reports to export correctly to Excel can be a challenge. Do you have the ability to edit the report that your software uses? If not, could you send .PDF files instead? (The export to PDF looks much better!)
If you can edit them, you would need to go into the report in Crystal and do the following:
1. Make the column headings and the data under them exactly the same width.
2. If any of your column headings are more than one line high (by actual text, not by the height of the text block) then they ALL must have the same number of lines of text. Your best bet is to try to make them just one line high.
3. Line up you column headings and data so that the left sides are at exactly the same place.
Most of the time following these steps will cause the report to line up as desired when exporting to Excel.
-Dell
IP Logged
