Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Crystal to csv in version 8.5

Status
Not open for further replies.
Dec 18, 2006
69
US
Hi all,

I created a very simple report in crystal version 8.5. I only have 2 columns (item ID and item description). When I exported my data to comma separated values (csv) using the export feature, my header prints on each line.

In Crystal:
Item ID Description
ABC Glue
XYZ Paper

In csv
Item ID, Description, ABC, Glue
Item ID, Description, XYZ, Paper

I am not sure what I'm missing. Can I not have the column headings? If I saved it to excel and then converted it to csv, it would work just fine. But that's defeating the purpose of having the csv export from crystal. Any advice is greatly appreciated.

Thanks in advance.

TTL101
 
This is still a problem with later versions of CR.

I have always had to export to CSV without headers and then add them back when importing the CSV file into your application.

Tools like Powershell 2 can add headers with command like

import-csv somefile.csv -Header "ItemID", "Description"

Ian
 
Bummer - I'm afraid that was the case.
Unfortunately crystal 8.5 doesn't have that option to isolate report/page section like in version 2008.
 
You can suppress page and report headers in 8.5.

Then export in csv without column titles.

Ian

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top