CSV export with header row problem

[JasonKaufman]

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!

 

[AndyMc]

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

 

[JasonKaufman]

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.

 

[kray4660]

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).