Crystal Reports XI R2 question
-
I've developed a Crystal Reports, and when exported to PDF, it looks great. It even looks great (to me) when exported to excel. However, one of the business users is stating they have an issue with it. Since some of the cells that are being used are wider than the default for excel it is merging the cell with data with the cells around it, and centering the data in the merged cells. Does anyone know how to tell it I don't want it to do this?
-
I've developed a Crystal Reports, and when exported to PDF, it looks great. It even looks great (to me) when exported to excel. However, one of the business users is stating they have an issue with it. Since some of the cells that are being used are wider than the default for excel it is merging the cell with data with the cells around it, and centering the data in the merged cells. Does anyone know how to tell it I don't want it to do this?
When exporting Crystal Reports to Excel, I have found these general rules help: 1. Use Guidelines extensively to ensure all fields are perfectly aligned vertically. 2. Avoid using Center alignment in fields. 3. Fields cannot overlap one another, otherwise extra rows will result in the spreadsheet. HTH!
Sincerely, -Mark mark@msdcweb.com http://www.msdcweb.com