[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

How do I force a line feed when I export data to Excel?

Hello,

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?
0
BrianMack
Asked:
BrianMack
  • 2
1 Solution
 
mlmccCommented:
How are you exporting?  What format are you choosing?

mlmcc
0
 
BrianMackAuthor Commented:
Microsoft Excel 97-2000 - Data Only XLS
0
 
frodomanCommented:
I believe this is a limitation of how the Excel export dll works.  I would recommend creating 3 different details sections in your report and putting one field in each of the sections (instead of arranging them vertically within the same sections).  When exported this should be treated as three different rows in your Excel spreadsheet.

frodoman
0
 
BrianMackAuthor Commented:
The worked great.  Thanks again!
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now