for some reason my header is repeating for every record all the way down the excel spreadsheet.

here is my code and i checked group settings and such to make sure that it's not set to repeat. any help would be great as i'm new to crystal reports.

WhilePrintingRecords;

Shared StringVar OutputFile;

StringVar Header := "";

Header :=

"LastName, FirstName, Annual Salary, FT/PT, Full/Part%, %Teaching, Ethnicity, Gender, AIMS Stats, NAIS Stas, RPCS Stats, Department, Adv. Degree" +

// Carriage Return / Line Feed
Header := Header + Chr(13) + Chr(10);

// Write line to file
mioMPAYIOAppendToFile (OutputFile, Header);

Header;

the actual header should only be across the top in individual cells and it's not. it's listed in one line and repeated for each employee.

thank you again in advance for any help or advice.

still returning header every other line for a new employee. i left just the header text and took out all code and it still does the same thing. 

go to export options and open up the options tab, turn off "export page header and page footer"

Put the header in a Report Header section and the rest of your data in a details section.  Also, you do NOT need to include the carriage return/line feed at the end of the formul - Crystal will automatically handle that in its export.

Are you exporting to "Separated Values (CSV)" or to "Text"?  Which version of Crystal are you using?