crystal reports adds header to front of each detail line in csv file

I am created a .csv data file with Crystal Reports.  It is a very simple file of employee information.  In the file, there is a report header that consists of a text box that I put the field names in, separated by commas.  In the details section, is the info for the records.  

This is what I want the file to look like:

First Name,Last Name,Start Date
John,Smith,5/15/2006
Roy,Jones,1/27/2002
Fred,Macker,3/18/1999

When I export the file to a .csv, this is what I get:

First Name,Last Name,Start Date,John,Smith,5/15/2006
First Name,Last Name,Start Date,Roy,Jones,1/27/2002
First Name,Last Name,Start Date,Fred,Macker,3/18/1999

When I export the file to a .xls or .txt file, the format is correct.  The header is listed once at the top of the file and the records then follow.

Any ideas why the .csv file is not working the same way?
MOISDTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
That is the way the CSV export is written.

There is an ooption in the CSV export to only print the headers once.

If you are exporting manually (from preview) check the options pop up and make sure that the ISOLATE PAGE HEADER and GROUP HEADER options are checked.

If you are using code then the same options should be available and set to TRUE

mlmcc
0
MOISDTechAuthor Commented:
Thank you for the reply, mlmcc.
I have attached 2 files to show what I am looking at.  I do not see the options you mention.  Am I not looking at the correct screen?
Thanks,
Roger

2010-03-31-1636.png
2010-03-31-1635.png
0
mlmccCommented:
Yes.  I get a much different second one
CSVExport.doc
0
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

MOISDTechAuthor Commented:
mlmcc,
Can you verify your version number for me?  I thought I had XI r2 on my system, but maybe it is just XI.  I do have XI r2 Server, but maybe my local install is just XI.
My version is 11.0.0.1282
Thanks,
Roger
0
mlmccCommented:
That is i believe the original CR XI R1.  It is definitely CR XI R1.  CR XI R2 is 11.5.x.xxxx
It may be a change added to CR XI R2.

You should be able to download the latest CR XI R2 and use your CR XI key code to install it.

Here is a link to the free trial versions.  They are limited to 30 days but the only thing you need is the key code.
http://www.sap.com/usa/solutions/sapbusinessobjects/sme/freetrials/index.epx

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
Just checked that is either SP1 or SP2 for CR XI R1.
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12986

mlmcc
0
MOISDTechAuthor Commented:
Thanks for the help.  I was able to get the update and all is well.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.