After moving a Crystal Report (created by fitting all the fields into the page width - Attachment #1) into CSS Portal and running the report to export into Excel, the field data and column headings are truncated and/or missing information.
Example: Column Heading - 'Agent Name' becomes 'Agen'
Data - 'John Smith' becomes 'John' or merges two columns to get 'John Smith'
Export settings for Excel (97-2003) Data-Only are in Attachment #2.
Any thoughts would be greatly appreciated.