CSV Export Settings

The CSV Export Settings are available if you select CSV as the export format.

Settings

Group Section Export Mode

Determines how group headers and footers are exported:

• Export: Headers and footers are exported as they are encountered in the report.
• ExportIsolated: Headers are written once, at the beginning of the file, and all footers are written once, at the end of the file.
• DoNotExport: Headers and footers are not exported.

You may need to experiment with settings to get the desired outcome based on how your report is structured. For example, if you are using grouping in your report and need the data from the group headers and footers written to the file, you should choose All sections exported.

Report Section ExportMode

Determines how report headers and footers are exported:

• Export: Headers and footers are exported as they are encountered in the report.
• ExportIsolated: Headers are written once, at the beginning of the file, and all footers are written once, at the end of the file.
• DoNotExport: Headers and footers are not exported.

Preserve Date Formatting

Determines whether the formatting applied to date fields is preserved on export.

Preserve Number Formatting

Determines whether the formatting applied to number fields is preserved on export.

Field Separator

The Separator is the character that is used to separate the values (columns) on each line of the export file. To use a tab character as the delimiter, enter {tab}.

String Delimiter

The String Delimiter is the character that is used to enclose string values in the export. Leave the box empty if you do not want to use a delimiter.