Problem with Header and Footer

[Yustrn]

Using Crystal 10 and have a header and footer system I need to use, seems to be fine, but when I run my report then try to export it as a .CSV file, I get a repeat of the header and footer for each line of data, when I just really want it one time for the whole report.

Here is an example of what I'm getting, and what I want to get.

***This is what I get***
HDR,10282007,16:45:12, , EXER.TXT|10004|0000001,16:45:12, ,|9|430980.00
HDR,10282007,16:45:12, , EXER.TXT|10004|00000016|05/01/2000|000024.410000000|01/18/2007|Same-Day Sale|1000|0|0.0000|00000000047.|00000000000.00||TRL,10282007,16:45:12, ,|9|430980.00

**This is what I want***

HDR,10282007,16:45:12, ,EXER.TXT 10004|00000016|05/01/2000||00000000000.00|00000000000.00|00000000000.00||

10004|00000016|05/01/2000|000024.410000000|01/18/2007|Same-Day Sale|1000|0|0.0000|00000000047.3400|0000000.00|00000000000.00||
TRL,10282007,16:45:12, ,|9|430980.00


Any suggestion on how to make it keep it's formatting?