Skip to Content
author's profile photo Former Member
Former Member

Separated Values (CSV) Problem

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2007 at 08:02 PM

    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 ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2007 at 08:53 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.