INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

CSV export with header row problem

CSV export with header row problem

(OP)
I have CR XI, CR developer, product type: full

I have a report that must be exported to CSV for upload of records to a website.
The main data is in a group header with the headers on the Page Header section.
I want the export to look like the below two rows

"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted"
"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"

Instead I get the following data exported into my CSV file.

"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"

I have seen the following instructions in other threads:
In the CSV export settings, do the following
1. Turn on Isolate Page/Report Sections.
2. Set Group Sections to Do Not Export.
When you set the format for the report, there's a checkbox that says "Use the export options defined in the report." This is on by default. Turn it off.

However, I do not see the export settings mentioned regarding "Isolate Page/report Sections"
When I select CSV to export, the only window that comes up after that is 'Character-Separated Values', after pressing ok, the report exports.

I have seen this thread:

http://www.tek-tips.com/viewthread.cfm?qid=420970

which indicates to create fake header and then apparently suppress all the headers/footers, which doesn't seem to work either.

Is there a reasonable solution to having column headers with data exported to CSV that doesn't involve changing registry keys or upgrading to SR Server.
Thanks!

RE: CSV export with header row problem

I have the same issue. I do one of two things as a work-around:

1. Suppress the header and copy/paste the header in after the export OR
2. Export to Excel and then save it as a CSV from Excel

-Andy

RE: CSV export with header row problem

(OP)
Thanks Andy...while that would normally work with no problem.

I should have added that this report will be on a scheduler, possibly using groffautomation software - still playing with it,
and then the run csv data would be scheduled to be emailed, so there would be no in between to doctor the report data.

RE: CSV export with header row problem

Another way is to 'cheat', build the data as one long text string. The important part is that the column headers are in the report header. Then export as a text file (with a .csv extension).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close