cancel
Showing results for 
Search instead for 
Did you mean: 

Separated Values (CSV) Problem

Former Member
0 Kudos

Post Author: jmb1977

CA Forum: Exporting

Hello, I am new to crystal reports and running into an exporting problem.

I work for a school district and I am trying to create a student report which contains multiple phone number contacts. Here is how I have it setup:

In my Group Header I have...Student # , First Name, Last Name, ..... Phone Number

Then in the Details section, I have the alternate contact phone number. I have it setup, using the selection expert, to grab multiple contacts if they exist.

So when I run the report it may look like this for an entry:

12345 John Doue 12 Student (000) 000-0000 .....

then on the next line have an alternate contact number and then on the next line, another number and so on.

The report looks fine when it is run, but when I do an export, using separated values (CSV), it places the alternate phone numbers on new lines, rather then as one record. So when I export it into Excel, it shows those numbers on next line down, rather then on the same line.

Any ideas? Using version 9.2.1.448 of the program.

Thanks,

Jason

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: yangster

CA Forum: Exporting

csv export options has been complete junk in crystal reports until the new recent release cr xi release 2you had to create fake page headers and other bogus crap to avoid it from spitting out repeating headers for every line of the report

Former Member
0 Kudos

Post Author: V361

CA Forum: Exporting

I am on CR XI, you could try creating a special formula.

& "," & & "," & & "," &

etc... This should comma seperate your data, export to txt, then have excel open that file. Not a great solution but it may work. Can you export to excel (data only) in version 9.2.1.448 ?