If you will be using reports to export data to a tab-delimited or comma-delimited files, you must place fields in the report layout in a special way so the export file has the proper format. The fields to export must be placed in the body of the report, in the order they are to appear in the export file. The following illustration shows the layout of a report to export customer information. Notice that the report contains only the Body section.
You must also add the ExportOneLineBody=TRUE setting to the defaults file. This setting causes the items in the report body to be exported to a single line in the export file. The following illustration shows the output file when the report above is exported to a comma-delimited file.