How do I force a line feed when I export data to Excel?
Posted on 2006-11-17
I have created a report with Crystal Reports XI. The report compares the records from two different sources. The report displays internal record detail on the first line of detail, external records detail on the second line and if any column of detail does not match the word 'Error' is displayed on the thrid line. All three lines are in the Details section. The problem comes when I export the data to Excel. Instead of producing three lines of detail in the worksheet, it creates one line of detail with all the three lines concatenated after each other. How do I force Excel to perform a line feed to match my output in CR?