Comma Separated Values
The output file will be in the CSV format and can be customized with the following options.
Exported Data
This option specifies if:
-
the created CSV file contains only the data of the report and no labels and layout information
-
the created CSV file contains column names in the first row
Text Qualifier
Specifies the character that will be used as text qualifier. By default, a quotation mark is used.
Line Break
Specifies the characters used for line breaks. By default the client operating system is used. The line break option:
-
Windows -
\r\n
, CR LF (Default) -
Mac OS -
\r
, CR -
Unix -
\n
, LF
Codepage
Specifies the encoding for the CSV file. By default, the server default encoding is used.
Column Delimiter
Specifies the delimiter that separates the fields. By default, a comma is used. Other values are Semicolon, Tab, other or "Fixed Width".
Fixed Width
If "Fixed Width" is used, then it is possible to specify a comma separated list of fixed column widths, e.g. 3,5,5
or 5,5,,4
. The following default values will be used for columns without specified width:
-
String: 8 characters
-
Number: 10 characters
-
Currency: 11 characters
-
Boolean: 6 characters
-
Date: 11 characters
-
Time: 9 characters
-
DateTime: 21 characters
If "Fixed Width" is used the exported CSV file will not contain column delimiters and text qualifier.