trailer record in fixed-length fields report

[mperera]

Hi,

I am working on a report that will produce a flat file of data. The fields are fixed length within the report. I need to append a trailer record with summary information as the last line of the report. I currently have this data in the report footer, and it is displaying properly in the report builder. However, as soon as I export the report to a flat file (character-separated values format), the data that is supposed to be appearing once at the end of the report appears appended to the end of each row (record) within the report. Does anyone know why this is happening? And what I can do to get around it?

Thanks.