Hey everybody - first post on the site, and this couldn't have come along at a better time.  I'm working in Crystal XI, and we have a custom built application that I'm importing reports into.  My problem is this.  When I export the report to Excel, the cells are merged, there's empty columns between columns that have data, data's not lining up properly, etc.  I've looked on the web, and the one site i found said to blow up the design view to 400% and line up the fields using the grid, so there is one column of dots between fields.  OK, have done that.  Now I've got the oppostie problem - the Report exports into Excel fine, but when I view it in Crystal/the application, the report looks like poo poo - columns are overlapping, i get ###### in a couple of my date fields (so the field's not big enough,  I know, but when I expand it the column doesn't work in Excel).  Anyone have suggestions?  Thanks a million, I really appreciate it.

In XI there are two options for exporting to Excel - plain export and data only.  The plain export is the one that does all the merged cells and other funky stuff in an effor to make it look like the report.  If you just want the data from the report in Excel so that it can be manipulated there, use the data only export.